Pages
- Blog
- 24/7 PostgreSQL Support
- Developer Support
- Webinar Library
- About 2ndQuadrant
- What Does “2ndQuadrant” Mean?
- News
- February 15, 2019 – Announcing the release of OmniDB 2.14
- February 4, 2019 – Barman v2.6 – Now with Support for Geo-redundancy
- December 20, 2018 – Announcing the release of OmniDB 2.13
- November 9, 2018 – Announcing Postgres Installer Updates for PostgreSQL 9.5, 9.6, 10 and 11
- October 31, 2018 – 2ndQuadrant partners with frontrunner in online trading to boost PostgreSQL performance by 400%!
- October 29, 2018 – pglogical 2.2.1 Released – Now with support for PostgreSQL 11
- October 25, 2018 – Announcing the release of Postgres-XL 10R1
- October 24, 2018 – repmgr 4.2 – Now with support for PostgreSQL 11
- October 23, 2018 – Announcing the Release of OmniDB 2.12
- October 23, 2018 – Barman v2.5 – Now with Support for PostgreSQL 11
- October 19, 2018 – Postgres Installer – Now available for PostgreSQL 11
- October 18, 2018 – 2ndQuadrant contributes major features to PostgreSQL 11
- October 15, 2018 – Postgres Installer – Now Available for PostgreSQL 11 RC1
- September 20, 2018 – Postgres Installer – Now Available for PostgreSQL 11 Beta 4
- September 17, 2018 – Announcing the release of Postgres-XL 10R1Beta1
- September 11, 2018 – Postgres Installer – Now with LDAP and Kerberos Support
- September 5, 2018 – Announcing the Release of repmgr 4.1.1
- August 23, 2018 – Announcing OmniDB 2.11 – Now with Support for PostgreSQL 11
- August 21, 2018 – CFP deadline for 2ndQuadrant PostgreSQL Conference has been extended!
- August 9, 2018 – Postgres Installer, now available with OmniDB Support
- July 31, 2018 – Announcing the Release of repmgr 4.1
- July 26, 2018 – Announcing the Release of OmniDB 2.10
- July 10, 2018 – Postgres Installer, now available with PostGIS Support
- June 29, 2018 – Announcing Postgres Installer for PostgreSQL 11 Beta 2
- June 26, 2018 – Announcing the Release of BDR 1.0.6
- June 19, 2018 – Announcing OmniDB 2.9 – Now with Plugin Support
- June 14, 2018 – Announcing the Release of repmgr 4.0.6
- June 07, 2018 – 2ndQuadrant PostgreSQL Conference 2018 officially opens Call for Papers and Registration
- May 30, 2018 – 2ndQuadrant Postgres-BDR selected by leading Chilean telecommunications company
- May 25, 2018 – Announcing the Release of Barman v2.4
- May 17, 2018 – OmniDB 2.8 Available – Now with Support for 3rd Generation Postgres-BDR
- May 10, 2018 – Announcing The Release of 2UDA for PostgreSQL 10.4, 9.6.9, 9.5.13
- May 3, 2018 – Announcing The Release of repmgr 4.0.5
- April 19, 2018 – 2ndQuadrant announces 3rd generation of Postgres-BDR
- April 12, 2018 – OmniDB 2.7 Released – Now with improved security and debugging features
- March 20, 2018 – Announcing the Release of pglogical 2.2
- March 16, 2018 – Announcing the Release of BDR 1.0.5
- March 15, 2018 – Announcing the Release of OmniDB 2.6
- March 9, 2018 – Announcing the Release of repmgr 4.0.4
- March 1, 2018 – Announcing the Release of 2UDA for PostgreSQL 10.3, 9.6.8, and 9.5.12
- February 15, 2018 – Announcing the Release of repmgr 4.0.3
- February 12, 2018 – OmniDB 2.5 Released – Now with Support for Oracle Databases
- January 18, 2018 – Announcing the Release of repmgr 4.0.2
- January 16, 2018 – Announcing the Release of OmniDB 2.4.1
- January 11, 2018 – Announcing the Release of pglogical 2.1.1
- December 13, 2017 – Announcing the Release of repmgr 4.0.1
- December 7, 2017 – Announcing The Release Of OmniDB 2.4
- December 5, 2017 – PostgreSQL webinar covering JSON Data Types announced by 2ndQuadrant
- November 29, 2017 – 2ndQuadrant enlisted by internationally recognized polar and marine research institute
- November 22, 2017 – Announcing the Release of Postgres-BDR 9.4.15
- November 21, 2017 – 2ndQuadrant Announces the Release of repmgr 4.0
- November 10, 2017 – Announcing The Release of 2UDA for PostgreSQL 10.1, 9.6.6, and 9.5.10
- November 2, 2017 – Announcing the Release of OmniDB 2.3
- October 30, 2017 – Announcing the Release of BDR 1.0.3
- October 19, 2017 – 2ndQuadrant CEO Simon Riggs to give keynote at PGConf.EU
- October 12, 2017 – Announcing the Release of OmniDB 2.2
- October 11, 2017 – Announcing the Release of repmgr v4.0 Beta
- October 10, 2017 – 2ndQuadrant CEO Simon Riggs to Speak at PGDay.IT
- October 9, 2017 – 2ndQuadrant Announces the Release of pglogical 2.1
- October 9, 2017 – Announcing the Release of 2UDA for PostrgreSQL 10
- October 5, 2017 – 2ndQuadrant contributes major features to PostgreSQL 10
- September 28, 2017 – Schedule for 2ndQuadrant PostgreSQL Conference 2017 Announced
- September 21, 2017 – Announcing The Release of 2UDA for PostgreSQL 10 RC1
- September 12, 2017 – Announcing the Release of OmniDB 2.1
- September 5, 2017 – Announcing the Release of Barman v2.3
- August 31, 2017 – 2ndQuadrant Achieves Best-in-Class Net Promoter Score
- August 28, 2017 – Announcing The Release of Postgres-XL 9.5r1.6
- August 25, 2017 – Announcing The Release of BDR 9.4.13
- August 22, 2017 – 2ndQuadrant Announces the Release of OmniDB
- August 10, 2017 – Announcing Release of 2UDA 9.5.8, 9.6.4 and PostgreSQL 10 Beta 3
- July 27, 2017 – Announcing 2ndQuadrant PostgreSQL Conference 2017
- July 17, 2017 – Announcing the Release of Barman 2.2
- July 14, 2017 – Case study – Global Award winning digital studio chooses BDR!
- July 13, 2017 – Announcing The Release of 2UDA Beta 2 for PostgreSQL 10
- July 12, 2017 – Announcing the release of BDR 2.0
- July 5, 2017 – Announcing the Release of Postgres-XL 10 alpha
- June 8, 2017 – Announcing the release of repmgr 3.3.2
- June 7, 2017 – Announcing the release of pglogical 2.0.1
- May 4, 2017 – Announcing the Release of pglogical 2.0
- May 18, 2017 – Announcing the release of 2UDA version 10 Beta 1
- May 18, 2017 – Announcing the release of BDR 9.4.12
- May 11, 2017 – Announcing the release of 2UDA 9.6.3 and 9.5.7
- April 28, 2017 – Book release! PostgreSQL 9 Administration Cookbook – Third Edition
- April 27, 2017 – Announcing the release of 2ndQPostgres
- April 20, 2017 – Announcing the Release of Postgres-XL 9.5r1.5
- March 24, 2017 – Announcing The Release of Postgres-BDR 9.4
- March 23, 2017 – Announcing The Release Of repmgr 3.3.1
- February 9, 2017 – Announcing The Release of 2UDA 9.6.2 and 9.6.5
- January 11, 2017 – New Service Launched – PostgreSQL Security Audit
- January 6, 2017 – Announcing The Release Of repmgr 3.3
- January 5, 2017 – Barman v2.1 Announced
- January 4, 2017 – Announcing The Release Of pglogical 1.2.2
- Announcing the Release of OmniDB 2.14
- Announcing the Release of Barman v2.7
- Announcing the release of repmgr 4.3
- OmniDB 2.7 released – Now with improved security and debugging features
- Announcing the Release of OmniDB 2.15
- Announcing Postgres Installer with New Updates
- Announcing the Release of Barman v2.8
- 2ndQuadrant listed amongst the 20 Most Promising IBM Solution Providers 2019
- Announcing Postgres Installer for PostgreSQL 12 Beta 1
- Announcing the Release of OmniDB 2.16
- Announcing Postgres Installer with New Security Updates
- Announcing the release of repmgr 4.4
- July 25, 2019 – Announcing the Release of pglogical 2.2.2
- 2ndQuadrant partners with Thales using BDR for advanced Data Security application
- August 1, 2019 – Announcing the Release of Barman v2.9
- Announcing Postgres Installer with New Security and Feature Updates
- October 3, 2019 – 2ndQuadrant contributes major features to PostgreSQL 12
- repmgr 5.0 released: Now with support for PostgreSQL 12
- December 5, 2019 – Announcing the Release of Barman v2.10
- OmniDB 2.17 Available – Now with Support for PostgreSQL 12
- 2ndQuadrant Becomes 1st Kubernetes Certified Service Provider (KCSP) for PostgreSQL
- February 19, 2020 – Announcing the Release of pglogical 2.3
- Announcing the release of repmgr 5.1
- Announcing Postgres Installer for PostgreSQL 13 Beta 1
- July 9, 2020 – Announcing the Release of Barman v2.11
- September 24, 2020 – 2ndQuadrant Contributes Major Features to PostgreSQL 13
- October 5, 2020 – Announcing the Release of pglogical 2.3.3
- Announcing the Release of repmgr 5.2.0
- Announcing the Release of OmniDB 3.0 – Now Supporting PostgreSQL 13
- EDB to Host Free Virtual Conference for PostgreSQL Users in Europe
- Announcing the Release of Barman v2.12
- Events
- Case Studies
- tastyworks Case Study Download
- Telefónica del Sur Case Study Form
- Animal Logic Case Study Form
- Alfred Wegener Institute Case Study Form
- Navionics Case Study Form
- Met Office Case Study Form
- Agilis Systems Case Study Form
- London & Partners Case Study Form
- Healthcare Software Solutions Case Study Form
- Performance Tuning
- Multi-Master Clusters
- Database Administration
- Professional Training
- Database Upgrades
- Database Migration
- Careers
- Team Profile
- Books
- Introducing PostgreSQL
- Training
- Course Catalog
- PostgreSQL Training Chicago
- Advanced Development & Performance
- Linux for PostgreSQL DBAs
- BDR
- PostgreSQL Database Administration
- PostgreSQL Data Warehousing & Partitioning
- PostgreSQL for Developers
- PostgreSQL Immersion
- PostgreSQL Immersion for Cloud Databases
- PostgreSQL Security
- Postgres-XL-10
- Practical SQL
- Replication, Backup & Disaster Recovery
- PostgreSQL Training London
- Courses
- Introduction to PostgreSQL and Kubernetes
- Contact Us
- Professional PostgreSQL
- Related Articles and Resources Template
- Postgres Learning Center
- Whitepapers
- Sitemap
- Videos
- Online Training
- Compliance at 2ndQuadrant
- Fireside Chats
- Upcoming Webinars
- Online Training: PostgreSQL Database Administration
- Online Training: PostgreSQL Database Administration
- Contact us
- test page for including related
- Blog Backlink
- test new page
- Services
- Products
- Remote DBA for PostgreSQL
- PostgreSQL Database Monitoring
- PostgreSQL Health Check
- PostgreSQL Performance Tuning
- PostgreSQL Database Security Audit
- Upgrade PostgreSQL
- PostgreSQL Migration Assessment
- Remote DBA for PostgreSQL
- Migrate from Oracle to PostgreSQL
- Postgres-BDR®
- 2ndQPostgres
- pglogical
- Replication & Failover Management for Postgres
- Barman
- SQL Firewall
- Postgres-XL
- omniDB
- Postgres Installer
- 2UDA
- AXLE
- PostgreSQL High Availability
- BDR
- pgpredict – Predictive Analytics for PostgreSQL
- Managed PostgreSQL in the Cloud
- Kubernetes Operators for Highly Available PostgreSQL and BDR
- IoT Solution
- Postgres-BDR® Deployment Options
- BDR – The 3rd Generation
- Installation Instructions for pglogical
- pglogical Documentation
- Release Notes
- Installation Instructions for repmgr
- Migrazione da Oracle®
- Predictive Analytics with 2UDA
- pgpredict – Tutorial
- Release Notes
Posts
2ndQuadrant
- Performance limits of logical replication solutions
- Postgres-XL 9.5R1Beta1 is here!
- Tables and indexes vs. HDD and SSD
- Planning to succeed
- Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!
- Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
- Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
- Load data in Postgres-XL at over 9M rows/sec
- Highlights of PGconf.EU
- On the impact of full-page writes
- Avoiding Disasters in New York
- CHAR(16) Scalability for Business
- CHAR16 Conf Panel Video
- PGDay.IT 2016 in Prato, Italy
- PostgreSQL’s Popularity Goes Up Again
- What does pg_start_backup() do?
- Using Java Database Interface (jDBI) with PostgreSQL
- Using Java ORMs with PostgreSQL – MyBatis
- Using EclipseLink with PostgreSQL
- Explaining CREATE INDEX CONCURRENTLY
- Dataloss at GitLab
- Autovacuum Tuning Basics
- PGConf India 2017 – An Event to Remember
- PgDay Paris 2017
- 2ndQuadrant – Not the Gartner Magic Quadrant
- In the defense of sar (and how to configure it)
- “Now is Better Than Never” – Why I decided to attend PyCon8…
- What’s new in Postgres-XL 9.6
- News and Roadmap for BDR (Multi-master PostgreSQL)
- News and Roadmap from Postgres-XL 10
- Oracle High Availability concepts in PostgreSQL
- pgxc_ctl: Teaching Postgres-XL in New York City
- PostgreSQL Meltdown Benchmarks
- PostgreSQL Developer Meeting Brussels
- PostgreSQL 11 – Server-side Procedures (Part 2)
- PostgreSQL – The most loved RDBMS
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Prague PostgreSQL Meetup
- PGConf APAC 2018 – bigger & better each year
- Don’t be hard-headed… Harden your PostgreSQL database to ensure security
- OmniDB: Console Tab
- Partition Elimination in PostgreSQL 11
- 2ndQuadrant at PostgresConf US 2018
- Introduction to Postgres-BDR [Webinar Follow-up]
- Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
- Data Modelling – It’s a lot more than just a diagram
- Scaling IoT Time Series Data with Postgres-BDR
- Postgres Installer – A Step by Step Guide to install PostgreSQL
- Postgres Installer by 2ndQuadrant – now supports OmniDB!
- Upgrading to PostgreSQL 11 with Logical Replication
- Adding new table columns with default values in PostgreSQL 11
- PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11
- PG Phriday: Studying Stored Procedures in Postgres 11
- PGDay Down Under 2018
- Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]
- Sequential UUID Generators
- Databases vs. encryption
- Webinar : Introduction to OmniDB [Follow Up]
- PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
- Webinar: pglogical and Postgres-BDR Update [Follow Up]
- CHAR (16) – Another conference on the horizon but with a focus on business
- Working towards Postgres-XL 9.5
- Tablesample and Other Methods for Getting Random Tuples
- Ansible Loves PostgreSQL
- PostgreSQL Planet in Ansible Galaxy
- Benchmarking Postgres-XL
- Performance of Sequences and Serials in Postgres-XL
- PgBouncer 1.7 – “Colors Vary After Resurrection”
- Postgres-XL: Dealing with read-only transactions
- Prague PostgreSQL Developer Day 2016
- FLOSS UK Spring Conference
- Are we ready for Nordic PGDay?
- pgpredict – Predictive analytics in PostgreSQL
- Postgres-XL 9.5r1 has finally arrived!
- On the usefulness of expression indexes
- Column Store Plans
- Postgres-XL 9.5r1.1 released
- PGLogical 1.1 packages for PostgreSQL 9.6beta1
- Auditing Users and Roles in PostgreSQL
- Application users vs. Row Level Security
- 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
- Second Edition of 5432…MeetUs!
- Conference isn’t enough?! Join us for post-conference training!
- Finding your PostgreSQL version
- Evolution of Fault Tolerance in PostgreSQL
- Evolution of Fault Tolerance in PostgreSQL: Replication Phase
- On the benefits of sorted paths
- Working Together to create an Open Source World
- PostgreSQL vs. Linux kernel versions
- Evolution of Fault Tolerance in PostgreSQL: Time Travel
- Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
- PostgreSQL 10 Roadmap
- Thoughts on Uber’s List of Postgres Limitations
- PostgreSQL Solutions Roadmap
- PostgreSQL 9.1 End of Life
- When to use Postgres-BDR or Postgres-XL?
- Postgres-BDR: 2 Years in Production
- Back to the Future Pt. 1: Introduction to pg_rewind
- Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
- The Best Barman Ever
- The PostgreSQL 9.6 release is almost here!
- Basics of Tuning Checkpoints
- PostgreSQL Solution Architecture
- When autovacuum does not vacuum
- How long does it take to change your mind?
- Webinar : Ansible & PostgreSQL [Follow Up]
- Postgres-XL and global MVCC
- Generated columns in PostgreSQL 12
- Partitioning enhancements in PostgreSQL 12
- PostgreSQL 12: Partitioning is now faster
- PostgreSQL 12: A Few Special-Case Performance Enhancements
- Webinar: New Features in Postgres 12 [Follow up]
- PostgreSQL 12: Foreign Keys and Partitioned Tables
- Managing another PostgreSQL Commitfest
- Postgres-BDR: It is also about fast safe upgrades
- PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
- Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
- Barman Cloud – Part 1: WAL Archive
- How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
- Releasing Cloud Native BDR Operator for Kubernetes
- Researching PostGIS slowness (2019 edition)
- Announcing New PostgreSQL Online Training Series
- How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)
- Webinar: All you need to know about CREATE STATISTICS [Follow Up]
- Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies
- How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
- How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)
- Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
- How to use Tree Machine Learning model with 2UDA – PostgreSQL and Orange (Part 4)
- How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)
- Oracle to PostgreSQL: START WITH/CONNECT BY
- Sequential UUID Generators on SSD
- How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6)
- Oracle to PostgreSQL: Basic Architecture
- Setting SSL/TLS protocol versions with PostgreSQL 12
- Oracle to PostgreSQL: Reasons to Migrate
- Local Persistent Volumes and PostgreSQL usage in Kubernetes
- PostgreSQL is the worlds’ best database
- How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
- Oracle to PostgreSQL – Binary Objects
- Machine Learning with 2UDA - PostgreSQL and Orange - Concluding the series
- Barman Cloud – Part 2: Cloud Backup
- Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
- Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
- PostgreSQL 13: Don’t let slots kill your primary
- Oracle to PostgreSQL — Cursors and Common Table Expressions
- Advanced partition matching for partition-wise join
- Webinar: PostgreSQL on Windows [Follow Up]
- Oracle to PostgreSQL — Cursors and ltrees
- Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 1
- Parallelism comes to VACUUM
- Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 2
- Image classification using 2UDA – Orange
- How to Get the Best Out of PostgreSQL Logs
- PostgreSQL 13: LIMIT … WITH TIES
- TPC-H performance since PostgreSQL 8.3
- Full-text search since PostgreSQL 8.3
- Smart R2DBC Repositories for PostgreSQL Databases
- PostgreSQL VACUUM and ANALYZE Best Practice Tips
- Webinar: Managing and Monitoring PostgreSQL Clusters with OmniDB [Follow Up]
- Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up]
- Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up]
Alvaro's PlanetPostgreSQL
- XMLTABLE in PostgreSQL
- Talk slides: Partitioning Improvements in PostgreSQL 11
- Partitioning Improvements in PostgreSQL 11
- Managing a PostgreSQL Commitfest
- Code coverage stats
- 9.6 Scariest Patch Tournament
- Column Store Plans
- PostgreSQL 12: Foreign Keys and Partitioned Tables
- Managing another PostgreSQL Commitfest
- Researching PostGIS slowness (2019 edition)
- PostgreSQL 11: Patch Reviewers for Partitioning Patches
- PostgreSQL 13: Don’t let slots kill your primary
- PostgreSQL 13: LIMIT … WITH TIES
Andrea's Planet PostgreSQL
Andrew's PlanetPostgreSQL
- Managed Database Services – pros and cons
- The rds_superuser role isn’t that super
- Problem with Buildfarm registrations fixed
- JSON version of XMLTABLE example
- Support for enums in btree_gin and btree_gist
- BuildFarm client release 4.19
- Out of tree builds
- Up to date access to postgres logs
- Announcing Release 5 of the PostgreSQL Buildfarm Client
- Setting up a build machine for Visual Studio 2017
- Announcing Release 6 of PostgreSQL Buildfarm client
- Buildfarm Client Bugfix Release 6.1
- PostgreSQL Buildfarm Client Release 8
- Road test your patch in one command
- Keeping our perl code clean
- Managing Freezing in PostgreSQL
- Adding new table columns with default values in PostgreSQL 11
- PostgreSQL Buildfarm Client Release 9
- Where and when you need a root.crt file
- PostgreSQL Buildfarm Client Release 10
- Buildfarm RSS feed
- Release 11 of the PostgreSQL Buildfarm client
- jsonb_set_lax
- [Video] Introduction to JSON data types in PostgreSQL
- Partitioning a large table without a long-running lock
- NSS on Windows for PostgreSQL development
- Updating the PostgreSQL root.crt file
- When to deploy or upgrade to a new major PostgreSQL release
Anna's PlanetPostgreSQL
- Barman 2.10 – Recovery of partial WAL files
- Barman Cloud – Part 2: Cloud Backup
- Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
Ashustosh's Planet PostgreSQL
Barman
- Barman 1.1.0
- Released Barman 1.1.1
- Barman 1.1.1 packages available for Ubuntu 12.04 (Precise Pangolin)
- Announcing Barman 1.3.0
- Announcing Barman 1.3.1
- Announcing Barman 1.3.3
- Announcing Barman 1.5.0
- Announcing Barman 1.6.0
- Oracle High Availability concepts in PostgreSQL
- Managing the backup of several PostgreSQL servers with Barman
- Barman 1.1.2 released
- Retention of backups with Barman
- Configuring retention policies in Barman
- Announcing Barman 1.2.1
- Announcing Barman 1.2.3
- Detecting smelly backups with Barman
- What’s new about Barman 1.4.0?
- Automating Barman with Puppet: it2ndq/barman (part one)
- Automating Barman with Puppet: it2ndq/barman (part two)
- Getting WAL files from Barman with ‘get-wal’
- Announcing Barman 1.5.1
- Barman 1.6.1 is Released
- Barman Cloud – Part 1: WAL Archive
- Barman Cloud – Part 2: Cloud Backup
- Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
Britt's Marketing
- PostgreSQL and the Platinum Guarantee
- Don’t be hard-headed… Harden your PostgreSQL database to ensure security
Britt's PlanetPostgreSQL
- “Now is Better Than Never” – Why I decided to attend PyCon8…
- Barman 1.6.1 is Released
- 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
- Second Edition of 5432…MeetUs!
Caterina's PlanetPostgreSQL
Cedric's FR PlanetePostgreSQL
Christian's PlanetPostgreSQL
Cloud Native
- Releasing Cloud Native BDR Operator for Kubernetes
- Automated rapid switchover with a BDR database cluster in Kubernetes
- How to deploy a multi-master BDR cluster in Kubernetes
- Local Persistent Volumes and PostgreSQL usage in Kubernetes
- Why we chose immutable application containers for our Cloud Native PostgreSQL and BDR products
Craig's PlanetPostgreSQL
- How do PostgreSQL security_barrier views work?
- Row security in PostgreSQL – Overview
- PostgreSQL anti-patterns: read-modify-write cycles
- How to find out which PostgreSQL table a file on disk corresponds to
- BDR History and future
- Re-import repository keys for BDR and pglogical apt repositories
- Traceable commit for PostgreSQL 10
- Using the PostgreSQL TAP framework in extensions
- Plan for the unexpected: install diagnostic tools on your PostgreSQL servers
- Using Multimaster and BDR appropriately – LinuxConfAu
- Dev Corner: error context stack corruption
- Improving PostgreSQL performance on AWS EC2
- During installation, cluster initialisation fails with the message “No error” on Windows
- Simplifying compilation of PostgreSQL on Windows
- PostgreSQL regression tests hanging on Windows? Check path depth.
- Testers needed for proposed 9.3 SEPostgreSQL enhancements
- Cygwin users needed to test a patch for PostgreSQL 9.3
- Help us make a better PostgreSQL 9.3!
- Choosing a PostgreSQL text search method
- Testing new PostgreSQL versions without messing up your existing install
- Tracing PostgreSQL with perf
- PostgreSQL guts: What is “resjunk”?
- Compiling PostgreSQL extensions with Visual Studio on Windows
- Streaming replication slots in PostgreSQL 9.4
- Putting a PostgreSQL tablespace on a ramdisk risks ALL your data
- PostgreSQL’s CTEs are optimisation fences
- Announcing BDR RPMs for 9.4
- pg_sysdatetime: a simple cross-platform PostgreSQL extension
- Compiling and debugging PostgreSQL’s PgJDBC under Eclipse
- Ware Yosemite? Possible PostgreSQL upgrade issues in OS X 10.10
- All-processes breakpoints / watchpoints for PostgreSQL
- BDR for PostgreSQL: Present and future
- Dynamic SQL-level configuration for BDR 0.9.0
- PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns
- BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released
- When are we going to contribute BDR to PostgreSQL?
- Emulating row security in PostgreSQL 9.4
- LVM: “Unable to create a snapshot smaller than 2 chunks”
- What is SKIP LOCKED for in PostgreSQL 9.5?
- Don’t set fsync=off if you want to keep your data
- Visual PostgreSQL debugging
- PostgreSQL-based application performance: latency and hidden delays
- How to check the lock level taken by operations in PostgreSQL
- BDR 1.0
- BDR is coming to PostgreSQL 9.6
- Transaction traceability in PostgreSQL 10 with txid_status(…)
- Using Docker Hub PostgreSQL images
- Developing on many versions of PostgreSQL at once
- A convenient way to launch psql against postgres while running pg_regress
- Failover slots for PostgreSQL
Data Mining
- Association rules with MADlib in Greenplum
- 2UDA – New features in Orange (Part 2)
- 2UDA RC1 – New features in Orange (Part 1)
- pgpredict – Predictive analytics in PostgreSQL
David's PlanetPostgreSQL
- Parallel Aggregate – Getting the most out of your CPUs
- Partition Elimination in PostgreSQL 11
- PostgreSQL 11: Partitioning Evolution from Postgres 9.6 to 11
- The PostgreSQL 9.6 release is almost here!
- Benchmark on a Parallel Processing Monster!
- PostgreSQL 12: Partitioning is now faster
DevOps
- Kanban & devops culture at 2ndQuadrant – Part 1
- Kanban & devops culture at 2ndQuadrant – Part 2
- Kanban & devops culture at 2ndQuadrant – Part 3
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Barman Cloud – Part 1: WAL Archive
- Barman Cloud – Part 2: Cloud Backup
- Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
Eisentraut's PlanetPostgreSQL
- More robust collations with ICU support in PostgreSQL 10
- PostgreSQL 10 identity columns explained
- Upgrading to PostgreSQL 11 with Logical Replication
- Maintaining feature branches and submitting patches with Git
- Developing PostgreSQL for Windows, Part 1
- Developing PostgreSQL for Windows, Part 2
- Developing PostgreSQL for Windows, Part 3
- A tale of password authentication methods in PostgreSQL
- PostgreSQL with passphrase-protected SSL keys under systemd
- Understanding user management in PgBouncer
- Unicode normalization in PostgreSQL 13
- Running multiple PgBouncer instances with systemd
- PostgreSQL, a community project
El Planeta PostgreSQL de Jaime
Elein’s PlanetPostgreSQL
- JOIN LATERAL
- Having Group By Clauses — elein’s GeneralBits
- Swoop de Dupe
- Beautiful things, strings.
- Postgresql Interval, Date, Timestamp and Time Data Types
- WITH a little help from my friends
Featured
- And Barman 1.6.0 is out!
- Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
- More ‘POWER’ for PostgreSQL
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Prague PostgreSQL Meetup
- CHAR (16) – Another conference on the horizon but with a focus on business
- The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
- Tablesample In PostgreSQL 9.5
- Ansible Loves PostgreSQL
- Benchmarking Postgres-XL
- Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
- JSONB and PostgreSQL 9.5: with even more powerful tools!
- Concurrent backups with Barman and PostgreSQL 9.6
- Evolution of Fault Tolerance in PostgreSQL
- Evolution of Fault Tolerance in PostgreSQL: Replication Phase
- PostgreSQL 9.6: Parallel Sequential Scan
- On the benefits of sorted paths
- Report from DatabaseCamp, NYC
- PostgreSQL vs. Linux kernel versions
- Evolution of Fault Tolerance in PostgreSQL: Time Travel
- Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
- Speed up getting WAL files from Barman
- Back to the Future Pt. 1: Introduction to pg_rewind
- Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
- The Best Barman Ever
- Barman Cloud – Part 1: WAL Archive
- Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies
Florins PlanetPostgreSQL
Francesco's PlanetPostgreSQL
- PostgreSQL 9.4 for administrators (part one)
- PostgreSQL 9.4 for administrators (part two)
- Automating Barman with Puppet: it2ndq/barman (part one)
- Automating Barman with Puppet: it2ndq/barman (part two)
- Automating Barman with Puppet: it2ndq/barman (part three)
- PostgreSQL 9.6: Parallel Sequential Scan
Gabriele's PlanetPostgreSQL
- Installing Greenplum Single Node Edition on Amazon’s EC2
- How to install multiple PostgreSQL servers on RedHat Linux
- Early bird registrations open for PGDay.IT 2011
- Call for papers for PGDay.IT 2011 has been extended
- PGDay.IT 2011 was “bellissimo”!
- Barman is finally out
- Management of the WAL archive in Barman
- Submit your talk for PGDay.IT
- PostgreSQL 9.3 development: Array ELEMENT Foreign Keys
- The “French Revolution”
- Call for papers for PGDay.IT has been extended
- Barman explained in a 83 seconds spot
- More ‘POWER’ for PostgreSQL
- PostgreSQL Meetup in Melbourne, Australia
- Kanban & devops culture at 2ndQuadrant – Part 3
- Barman 2.2 and the magic of parallel copy
- The Barman is ready for PostgreSQL 10
- Australia: Last seats for our PostgreSQL courses in Melbourne
- My “top 5” for PGConf.eu in Prague
- 79 real attendees at the Italian PGDay
- Managing the backup of several PostgreSQL servers with Barman
- It’s a long way to Melbourne if you want to rock ‘n’ roll with Postgres!
- Retention of backups with Barman
- The first Australian PostgreSQL Day
- Configuring retention policies in Barman
- How to safely change the “postgres” user password via “psql”
- OSS4B 2013, innovate through Open Source
- Postgres and devops: testing 9.3 with Vagrant and Puppet – part one
- Postgres and devops: testing 9.3 with Vagrant and Puppet – part two
- Managing PostgreSQL in a devops environment
- Detecting smelly backups with Barman
- Italian PGDay, eighth edition: over 120 attendees!
- How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver
- Incremental backup with Barman 1.4.0
- Getting WAL files from Barman with ‘get-wal’
- Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
- Waiting for Barman 1.6.1
- Concurrent backups with Barman and PostgreSQL 9.6
- Speed up getting WAL files from Barman
- The Best Barman Ever
- Geo-redundancy of PostgreSQL database backups with Barman
- Backup manifests and pg_verifybackup in PostgreSQL 13
- Which partition contains a specific row in my PostgreSQL database?
Gianni's PlanetPostgreSQL
- Some ideas about low-level resource pooling in PostgreSQL
- pgChess code published
- CTE and the Birthday Paradox
- PostgreSQL User Group NL
Giulio's PlanetPostgreSQL
- Barman 2.1 and the new –archive option
- What’s new about Barman 1.4.0?
- PostgreSQL 9.5: IMPORT FOREIGN SCHEMA
- 2ndQuadrant speaks at PostgreSQL sessions
Giuseppe's PlanetPostgreSQL
- BRIN for PostGIS: my story at the Code Sprint 2016 in Paris
- Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
- The CHECK clause for updatable views
- NoSQL with PostgreSQL 9.4 and JSONB
- The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4
- Back to the Future Pt. 1: Introduction to pg_rewind
- Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5
Greenplum
- Installing Greenplum Single Node Edition on Amazon’s EC2
- Installing PostGIS on Greenplum Single Node Edition
- Installing Greenplum Single Node Edition on Ubuntu 10.4 (Lucid)
- Performing parallel ETL with Greenplum’s gpfdist and external tables
- How to test Greenplum Community Edition on VirtualBox
- Association rules with MADlib in Greenplum
- ETL with Talend and Greenplum – Part one: connections
- Using PL/Java in Greenplum
- ETL with Talend and Greenplum – Part two: data import
- Using dblink in Greenplum
- ETL with Kettle and Greenplum – Part one: setting up your job.
- Using gpmigrator in Greenplum 4.1.1
- ETL with Kettle and Greenplum – Part Two: importing data
- Mapreduce in Greenplum 4.1
- Performing ETL using Kettle with GPFDIST and GPLOAD
- Mapreduce in Greenplum 4.1 – 2nd part
- Using Greenplum 4.1 in Ubuntu 11.10
- A Greenplum 4.1 installation handbook
- How to initialize Greenplum on multiple nodes
- Greenplum 4.2 is out!
- Setting JDBC with Greenplum
- External web tables in Greenplum
- Greenplum CE 4.2 XML support
- How to test Greenplum Community Edition 4.2.1 on VirtualBox
- How to install fuzzystrmatch on Greenplum Community Edition
Greg's PlanetPostgreSQL
- Trade-offs in Hot Standby Deployments
- PGEast, Hardware Benchmarking, and the PG Performance Farm
- AMD, Intel, and PostgreSQL
- The Return of XFS on Linux
- PostgreSQL, FreeBSD, and Free Dog Food
- Heads in the cloud at CHAR(10)
- PostgreSQL Performance and PGWest
- “PostgreSQL 9.0 High Performance” book is out
- PG West talks
- PostgreSQL CommitFest #3 for 9.1 needs you!
- Easier PostgreSQL 9.0 clusters with repmgr
- How not to build PostgreSQL 9.0 extensions on RPM platforms
- Tuning Linux for low PostgreSQL latency
- Hinting at PostgreSQL
- Data generation and hardware quality
- Spring 2011 PostgreSQL Conferences, US/Canada
- PostGIS In Action
- The cost of free PostgreSQL publicity
- Planetary alignment
- Measuring PostgreSQL Checkpoint Statistics
- Telling Your Users to Go Fork Themselves
- Updates to PostgreSQL testing tools with benchmark archive
- Reducing the postgresql.conf, parameter at a time
- Linux filesystems and PostgreSQL checkpoint benchmarks
- Intel SSD, now off the sh..err, shamed list
Gulcin's PlanetPostgreSQL
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Prague PostgreSQL Meetup
- Tablesample In PostgreSQL 9.5
- What’s New in PgBouncer 1.6
- Tablesample and Other Methods for Getting Random Tuples
- Ansible Loves PostgreSQL
- PostgreSQL Planet in Ansible Galaxy
- PgBouncer 1.7 – “Colors Vary After Resurrection”
- Prague PostgreSQL Developer Day 2016
- FLOSS UK Spring Conference
- Are we ready for Nordic PGDay?
- Evolution of Fault Tolerance in PostgreSQL
- Evolution of Fault Tolerance in PostgreSQL: Replication Phase
- Evolution of Fault Tolerance in PostgreSQL: Time Travel
- Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
Haroon's PlanetPostgreSQL
- PostgreSQL Time-based Partitioning for IoT Data using pg_partman
- PostgreSQL 10 easy installation with 2UDA
- Using Window Functions for Time Series IoT Analytics in Postgres-BDR
- Scaling IoT Time Series Data with Postgres-BDR
- PostgreSQL and IoT Data Localization, Integration, and Write Scalability
- PostgreSQL for IoT Data Retention and Archiving
- PostgreSQL: Regular expressions and pattern matching
- RESTful CRUD API using PostgreSQL and Spring Boot – Part one
- RESTful CRUD API using PostgreSQL and Spring Boot – Part 2
- Bulk transactions with RESTful CRUD API using PostgreSQL and Spring Boot
- Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA
- Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 1
- Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 2
- Smart R2DBC Repositories for PostgreSQL Databases
Howard Postgres Marketing World
Howard's PlanetPostgreSQL
- Enterprise Support – The final hurdle for PostgreSQL?
- CHAR (16) – Another conference on the horizon but with a focus on business
Ian's PlanetPostgreSQL
- repmgr 3.2 is here with Barman support and Brand New High Availability features
- repmgr 3.3
- Japan PostgreSQL Conference 2014
- Letter from Japan
- Improvements in repmgr 3.1.4
- Replication configuration changes in PostgreSQL 12
International News
- Hot Standby User Group (online) – 13 Jan at 1600UTC
- 2ndQuadrant US Launch Party – February 12 New York City – Canceled
- Heads in the cloud at CHAR(10)
- “PostgreSQL 9.0 High Performance” book is out
- Easier PostgreSQL 9.0 clusters with repmgr
- PostgreSQL training for MySQLers
- 2ndQuadrant Deutschland – Special Training Opening Bargain
- PostgreSQL agent in SQL Standard committee again
- EuroPython 2011: “The Python and the Elephant”
- Soon! 4-Days Admin Training in German
- Announcing Barman 1.3.0
- Announcing Barman 1.3.1
- Announcing Barman 1.3.3
- Announcing Barman 1.5.0
- Announcing Barman 1.6.0
- Extended the call for papers for “5432…MeetUs!”
- PostgreSQL User Group NL
- Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!
- Prague PostgreSQL Meetup
- Australia: Last seats for our PostgreSQL courses in Melbourne
- Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL
- Barman 1.1.2 released
- Announcing Barman 1.2.1
- Announcing Barman 1.2.3
- Announcing Barman 1.5.1
- Barman 1.6.1 is Released
- 5432…MeetUs! Conference Gives Opportunities for Meaningful Takeaways
- Second Edition of 5432…MeetUs!
- Conference isn’t enough?! Join us for post-conference training!
Internet of Things
- PostgreSQL Time-based Partitioning for IoT Data using pg_partman
- Using Window Functions for Time Series IoT Analytics in Postgres-BDR
- Scaling IoT Time Series Data with Postgres-BDR
- PostgreSQL and IoT Data Localization, Integration, and Write Scalability
- PostgreSQL for IoT Data Retention and Archiving
Jaime's PlanetPostgreSQL
Jimmy's Planet PostgreSQL
John’s PlanetPostgreSQL
- Optimizing storage of small tables in PostgreSQL 12
- PostgreSQL 12: A Few Special-Case Performance Enhancements
Jonathan's PlanetPostgreSQL
Josette's PlanetPostgreSQL
Kirk’s PlanetPostgreSQL
- Generated columns in PostgreSQL 12
- Partitioning enhancements in PostgreSQL 12
- PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
- Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
- Oracle to PostgreSQL: START WITH/CONNECT BY
- Oracle to PostgreSQL: Basic Architecture
- Oracle to PostgreSQL: Reasons to Migrate
- PostgreSQL is the worlds’ best database
- Oracle to PostgreSQL – Binary Objects
- Oracle to PostgreSQL — Cursors and Common Table Expressions
- Oracle to PostgreSQL — Cursors and ltrees
Koichi’s PlanetPostgreSQL
Lan's PlanetPostgreSQL
Liaqat's PlanetPostgreSQL
- Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
- Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]
- Webinar: Data Integration With PostgreSQL [Follow Up]
- Power of Indexing in PostgreSQL [Webinar Follow-up]
- Introduction to Postgres-BDR [Webinar Follow-up]
- Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
- Postgres Installer – A Step by Step Guide to install PostgreSQL
- Webinar : Database Security in PostgreSQL [Follow Up]
- Webinar : New Features in PostgreSQL 11 [Follow Up]
- Webinar: PostgreSQL is NOT your traditional SQL database [Follow Up]
- Webinar : Introduction to OmniDB [Follow Up]
- PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
- Webinar: pglogical and Postgres-BDR Update [Follow Up]
- Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
- Webinar : Ansible & PostgreSQL [Follow Up]
- Security and Compliance with PostgreSQL [Webinar]
- Migration to PostgreSQL [Webinar]
- Postgres Vacuuming Through Pictures [Webinar]
- Business Intelligence with Window Functions in PostgreSQL [Webinar]
- New Features in PostgreSQL 13 [Full Webinar Video]
Marco's PlanetPostgreSQL
Mark's PlanetPostgreSQL
- Loading Tables and Creating B-tree and Block Range Indexes
- Index Overhead on a Growing Table
- SCALE 14x
- Visualizing sar data
- Testing Postgres-XL with DBT-3
- PostgreSQL Award
- Adventure in programming languages and simple statistics
- Creating a PostgreSQL procedural language – Part 1 – Setup
- Creating a PostgreSQL procedural language – Part 2 – Embedding Julia
- Creating a PostgreSQL procedural language – Part 3 – Executing User Code
- Creating a PostgreSQL procedural language – Part 4 – Handling Input Parameters
- Creating a PostgreSQL procedural language – Part 5 – Returning Results
- Random numbers
- Random Data
Marriya's PlanetPostgreSQL
Masahiko's Planet PostgreSQL
Nouman's PlanetPostgreSQL
OmniDB
- OmniDB: Average execution time of PostgreSQL webmethods
- PostgreSQL 10 Logical Replication with OmniDB
- Postgres-BDR with OmniDB
- Postgres-XL with OmniDB
- pglogical with OmniDB
- OmniDB – Now with PL/pgSQL debugger!
- Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
- OmniDB: Monitoring Dashboard
- Oracle with OmniDB
- OmniDB: Console Tab
- Postgres-BDR 3.0 with OmniDB
- Postgres Installer by 2ndQuadrant – now supports OmniDB!
- OmniDB debugger for PostgreSQL 11
- Webinar : Introduction to OmniDB [Follow Up]
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
Pallavi's PlanetPostgreSQL
Pavan's PlanetPostgreSQL
- Postgres-XL 9.5R1Beta1 is here!
- Sharding: Bringing back Postgres-XL technology into core PostgreSQL
- How will Postgres-XL exploit the Parallel Query Capabilities of PostgreSQL 9.6?
- Load data in Postgres-XL at over 9M rows/sec
- Postgres-XL Scalability for Loading Data
- Explaining CREATE INDEX CONCURRENTLY
- Corruption in CREATE INDEX CONCURRENTLY
- Looking forward to PGConf India 2017
- PGConf India 2017 – An Event to Remember
- News and Roadmap from Postgres-XL 10
- [Video] Power of Indexing in PostgreSQL
- Working towards Postgres-XL 9.5
- Benchmarking Postgres-XL
- Performance of Sequences and Serials in Postgres-XL
- Postgres-XL: Dealing with read-only transactions
- Looking forward to PGDay India 2016
- Postgres-XL 9.5R1Beta2 Released!
- Postgres-XL 9.5r1 has finally arrived!
- Postgres-XL 9.5r1.1 released
Petr's PlanetPostgreSQL
- Logical Replication in PostgreSQL 10
- pglogical 2.1 and Logical Replication in PostgreSQL 10
- Progress on online upgrade
- PGLogical 1.1 released with sequence support and more
- PGLogical 1.1 packages for PostgreSQL 9.6beta1
- pglogical 1.2 with PostgreSQL 9.6 support
pglogical
- The process that created pglogical
- Performance limits of logical replication solutions
- PG Phriday: pglogical and Postgres 10 Partitions
- pglogical with OmniDB
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Why Logical Replication?
- On pglogical performance
- FLOSS UK Spring Conference
- PGLogical 1.1 released with sequence support and more
- PGLogical 1.1 packages for PostgreSQL 9.6beta1
- Untangling the PostgreSQL upgrade
Postgres Installer
- Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
- Postgres Installer – A Step by Step Guide to install PostgreSQL
- Postgres Installer by 2ndQuadrant – now supports OmniDB!
Postgres-XL
PostgreSQL
- Trade-offs in Hot Standby Deployments
- PGEast, Hardware Benchmarking, and the PG Performance Farm
- AMD, Intel, and PostgreSQL
- The Return of XFS on Linux
- How to install multiple PostgreSQL servers on RedHat Linux
- PostgreSQL, FreeBSD, and Free Dog Food
- Some ideas about low-level resource pooling in PostgreSQL
- Heads in the cloud at CHAR(10)
- “PostgreSQL 9.0 High Performance” book is out
- How not to build PostgreSQL 9.0 extensions on RPM platforms
- Hinting at PostgreSQL
- Data generation and hardware quality
- PostgreSQL training for MySQLers
- 2ndQuadrant Deutschland – Special Training Opening Bargain
- Spring 2011 PostgreSQL Conferences, US/Canada
- PostgreSQL agent in SQL Standard committee again
- PostGIS In Action
- The cost of free PostgreSQL publicity
- Planetary alignment
- Early bird registrations open for PGDay.IT 2011
- Call for papers for PGDay.IT 2011 has been extended
- CTE and the Birthday Paradox
- How do PostgreSQL security_barrier views work?
- Announcing repmgr 2.0RC2
- Announcing repmgr 2.0
- Indexando ando: Índices GIN
- Performance limits of logical replication solutions
- Tables and indexes vs. HDD and SSD
- PostgreSQL User Group NL
- On the impact of full-page writes
- Looking forward to PGConf India 2017
- Autovacuum Tuning Basics
- XMLTABLE in PostgreSQL
- More robust collations with ICU support in PostgreSQL 10
- In the defense of sar (and how to configure it)
- PostgreSQL 10 identity columns explained
- What’s new in Postgres-XL 9.6
- Future of Postgres-XL
- Oracle High Availability concepts in PostgreSQL
- Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
- PostgreSQL Meltdown Benchmarks
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)
- Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)
- Prague PostgreSQL Meetup
- 2ndQuadrant at PostgresConf US 2018
- Postgres Installer – A GUI based, user-friendly installer for PostgreSQL
- Postgres Installer – A Step by Step Guide to install PostgreSQL
- Talk slides: Partitioning Improvements in PostgreSQL 11
- Managing Freezing in PostgreSQL
- [Video] Data Integration with PostgreSQL
- Upgrading to PostgreSQL 11 with Logical Replication
- Partitioning Improvements in PostgreSQL 11
- [Video] Power of Indexing in PostgreSQL
- Webinar : New Features in PostgreSQL 11 [Follow Up]
- [Video] Ansible and PostgreSQL
- PostgreSQL 9.3 EOL – Why is it Important to Upgrade?
- Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
- JOIN LATERAL
- Measuring PostgreSQL Checkpoint Statistics
- Telling Your Users to Go Fork Themselves
- Updates to PostgreSQL testing tools with benchmark archive
- Reducing the postgresql.conf, parameter at a time
- Linux filesystems and PostgreSQL checkpoint benchmarks
- Intel SSD, now off the sh..err, shamed list
- Announcing Barman 1.0, Backup and Recovery Manager for PostgreSQL
- Tracing PostgreSQL with perf
- PostgreSQL guts: What is “resjunk”?
- Progress on online upgrade
- The CHECK clause for updatable views
- Automating Barman with Puppet: it2ndq/barman (part one)
- Automating Barman with Puppet: it2ndq/barman (part two)
- Why should you learn PostgreSQL?
- What’s New in PgBouncer 1.6
- Working towards Postgres-XL 9.5
- Tablesample and Other Methods for Getting Random Tuples
- Ansible Loves PostgreSQL
- PostgreSQL Planet in Ansible Galaxy
- Benchmarking Postgres-XL
- Performance of Sequences and Serials in Postgres-XL
- On pglogical performance
- PgBouncer 1.7 – “Colors Vary After Resurrection”
- Prague PostgreSQL Developer Day 2016
- FLOSS UK Spring Conference
- Managing a PostgreSQL Commitfest
- Are we ready for Nordic PGDay?
- pgpredict – Predictive analytics in PostgreSQL
- Code coverage stats
- On the usefulness of expression indexes
- 9.6 Scariest Patch Tournament
- Column Store Plans
- PGLogical 1.1 packages for PostgreSQL 9.6beta1
- Auditing Users and Roles in PostgreSQL
- PostgreSQL-based application performance: latency and hidden delays
- Application users vs. Row Level Security
- Evolution of Fault Tolerance in PostgreSQL
- Evolution of Fault Tolerance in PostgreSQL: Replication Phase
- PostgreSQL 9.6: Parallel Sequential Scan
- On the benefits of sorted paths
- PostgreSQL vs. Linux kernel versions
- pgFincore 1.2, une extension PostgreSQL
- Evolution of Fault Tolerance in PostgreSQL: Time Travel
- Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
- Those darn Large Objects
- Untangling the PostgreSQL upgrade
- Basics of Tuning Checkpoints
- When autovacuum does not vacuum
- Having Group By Clauses — elein’s GeneralBits
- Postgres is the coolest database – Reason #1: Developers love it!
- Postgres is the coolest database – Reason #2: The License
- Webinar: New Features in Postgres 12 [Follow up]
- PostgreSQL 12: Foreign Keys and Partitioned Tables
- Managing another PostgreSQL Commitfest
- PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
- Developing PostgreSQL for Windows, Part 1
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
- Barman Cloud – Part 1: WAL Archive
- How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
- Researching PostGIS slowness (2019 edition)
- Developing PostgreSQL for Windows, Part 2
- How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
- Developing PostgreSQL for Windows, Part 3
- A tale of password authentication methods in PostgreSQL
- Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL
- Oracle to PostgreSQL: START WITH/CONNECT BY
- PostgreSQL 11: Patch Reviewers for Partitioning Patches
- [Video] Introduction to JSON data types in PostgreSQL
- Oracle to PostgreSQL: Basic Architecture
- Oracle to PostgreSQL: Reasons to Migrate
- PostgreSQL is the worlds’ best database
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
- Unicode normalization in PostgreSQL 13
- Barman Cloud – Part 2: Cloud Backup
- Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
- PostgreSQL 13: Don’t let slots kill your primary
- Oracle to PostgreSQL — Cursors and Common Table Expressions
- Advanced partition matching for partition-wise join
- Oracle to PostgreSQL — Cursors and ltrees
- Parallelism comes to VACUUM
- How to Get the Best Out of PostgreSQL Logs
- PostgreSQL 13: LIMIT … WITH TIES
- OLTP performance since PostgreSQL 8.3
- TPC-H performance since PostgreSQL 8.3
- Full-text search since PostgreSQL 8.3
- 7 Best Practice Tips for PostgreSQL Bulk Data Loading
- PostgreSQL VACUUM and ANALYZE Best Practice Tips
- How EDB Became the Leader in the Postgres Market
PostgreSQL 13
- PostgreSQL 13: Don’t let slots kill your primary
- Advanced partition matching for partition-wise join
- Parallelism comes to VACUUM
- How to Get the Best Out of PostgreSQL Logs
- PostgreSQL 13: LIMIT … WITH TIES
- 7 Best Practice Tips for PostgreSQL Bulk Data Loading
- PostgreSQL VACUUM and ANALYZE Best Practice Tips
Rafael's PlanetPostgreSQL
repmgr
- Announcing repmgr 2.0RC2
- Announcing repmgr 2.0
- repmgr 3.2 is here with Barman support and Brand New High Availability features
- Announcing repmgr 2.0RC1
- Replication configuration changes in PostgreSQL 12
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
Rubens' PlanetPostgreSQL
- And Barman 1.6.0 is out!
- Inserting JSONB data in PostgreSQL 9.6
- JSONB and PostgreSQL 9.5: with even more powerful tools!
Sadeq's PlanetPostgreSQL
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 1
- How to Automate PostgreSQL 12 Replication and Failover with repmgr – Part 2
- How to Protect Your PostgreSQL Databases from Cyberattacks with SQL Firewall
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 1
- How to Monitor PostgreSQL 12 Performance with OmniDB – Part 2
- How to Get the Best Out of PostgreSQL Logs
- 7 Best Practice Tips for PostgreSQL Bulk Data Loading
- PostgreSQL VACUUM and ANALYZE Best Practice Tips
Seemab's PlanetPostgreSQL
- How to use the KNN Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 1)
- How to use the SVM Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 2)
- How to use the Random Forest Machine Learning Model with 2UDA – PostgreSQL and Orange (Part 3)
- How to use Tree Machine Learning model with 2UDA – PostgreSQL and Orange (Part 4)
- How to use Logistic Regression Machine Learning model with 2UDA – PostgreSQL and Orange (Part 5)
- How to use AdaBoost Machine Learning model with 2UDA – PostgreSQL and Orange (Part 6)
- How to use Neural Network Machine Learning model with 2UDA – PostgreSQL and Orange (Part 7)
- Machine Learning with 2UDA - PostgreSQL and Orange - Concluding the series
Shaun's PlanetPostgreSQL
- PG Phriday: Dearly De-parted
- PG Phriday: Postgres on Tap
- PG Phriday: Uptown Func
- PG Phriday: Crazy Correlated Column Crusade
- PG Phriday: Smooth Operator
- PG Phriday: pglogical and Postgres 10 Partitions
- PG Phriday: Getting RAD with Docker [Part 1]
- PG Phriday: Getting RAD with Docker [Part 3]
- PG Phriday: Getting RAD with Docker [Part 4]
- PG Phriday: Postgres on ZFS
- PG Phriday: Adventures in BAR Management
- PG Phriday: Securing PgBouncer
- [Video] Data Integration with PostgreSQL
- On Rocks and Sand
- PG Phriday: Studying Stored Procedures in Postgres 11
- PG Phriday: PgBouncer or Bust
- PG Phriday: Terrific Throughput Tracking
- PG Phriday: Getting RAD with Docker [Part 2]
- PG Phriday: BDR Around the Globe
- I am Developer! (And You Can Too!)
- PG Phriday: Around the World in Two Billion Transactions
- PG Phriday: Postgres 12 Revs up Vacuum
- PG Phriday: 10 Things Postgres Could Improve – Part 1
- PG Phriday: 10 Things Postgres Could Improve – Part 2
- PG Phriday: It’s the End of the World as We Know it (and Postgres is Fine)
- PG Phriday: 10 Things Postgres Could Improve – Part 3
Simon's PlanetPostgreSQL
- Planning to succeed
- Cool Runnings
- Highlights of PGconf.EU
- Avoiding Disasters in New York
- CHAR(16) Scalability for Business
- CHAR16 Conf Panel Video
- PostgreSQL’s Popularity Goes Up Again
- What does pg_start_backup() do?
- Dataloss at GitLab
- PgDay Paris 2017
- PostgreSQL Popularity Continues to Grow!
- News and Roadmap for BDR (Multi-master PostgreSQL)
- PG10 at the London PostgreSQL Meetup
- Why PostgreSQL is better than MySQL
- Oracle High Availability concepts in PostgreSQL
- PostgreSQL is the DBMS of the Year 2017
- PostgreSQL Meltdown
- Upcoming Enhancements to Partitioning & Indexes in PostgreSQL 11
- PostgreSQL Maximum Table Size
- PostgreSQL Developer Meeting Brussels
- PostgreSQL – The most loved RDBMS
- The End of MongoDB
- Joins Don’t Scale!
- Why Logical Replication?
- The Physics of Multi-Master
- PgDay France 2016
- Finding your PostgreSQL version
- Oracle’s rising open source problem
- Report from DatabaseCamp, NYC
- PostgreSQL 10 Roadmap
- Thoughts on Uber’s List of Postgres Limitations
- PostgreSQL Solutions Roadmap
- PostgreSQL 9.1 End of Life
- When to use Postgres-BDR or Postgres-XL?
- Postgres-BDR: 2 Years in Production
- PostgreSQL Solution Architecture
- How long does it take to change your mind?
- Supporting the Elephant
Susanne's PlanetPostgreSQL
Technology
Time Series Data
Tom's PlanetPostgreSQL
- pgxc_ctl: Teaching Postgres-XL in New York City
- [Video] Ansible and PostgreSQL
- Postgres-BDR: It is also about fast safe upgrades
Tomas' PlanetPostgreSQL
- Performance limits of logical replication solutions
- Tables and indexes vs. HDD and SSD
- On the impact of full-page writes
- Autovacuum Tuning Basics
- In the defense of sar (and how to configure it)
- What’s new in Postgres-XL 9.6
- Future of Postgres-XL
- PostgreSQL Meltdown Benchmarks
- Sequential UUID Generators
- Databases vs. encryption
- On pglogical performance
- On the usefulness of expression indexes
- Auditing Users and Roles in PostgreSQL
- Application users vs. Row Level Security
- On the benefits of sorted paths
- PostgreSQL vs. Linux kernel versions
- Basics of Tuning Checkpoints
- When autovacuum does not vacuum
- Sequential UUID Generators on SSD
- OLTP performance since PostgreSQL 8.3
- TPC-H performance since PostgreSQL 8.3
- Full-text search since PostgreSQL 8.3
training
Umair's PlanetPostgreSQL
- The process that created pglogical
- Postgres-XL 9.5: Gearing Towards the Beta Release
- Using Hibernate Query Language (HQL) with PostgreSQL
- Committed to the PostgreSQL Community, 2ndQuadrant Contributes to 9.6
- The PostgreSQL License – What Does It Mean For My Business?
- Processing PostgreSQL JSON & JSONB data in Java
- JOOQ Object Oriented Querying (jOOQ)
- Using Java Database Interface (jDBI) with PostgreSQL
- Using Java ORMs with PostgreSQL – MyBatis
- Using EclipseLink with PostgreSQL
- PostgreSQL 11 – Server-side Procedures (Part 1)
- PostgreSQL 11 – Server-side Procedures (Part 2)
- PGConf APAC 2018 – bigger & better each year
- Creating a PostgreSQL Service on Ubuntu
- 2ndQ talks at PGDay FOSDEM 2016
- Using Java arrays to insert, retrieve, & update PostgreSQL arrays
- Using Java Object Oriented Querying (jOOQ) with PostgreSQL
- Using Querydsl with PostgreSQL
- My experience with the Indonesia PUG meetup
- 2UDA – Installing PostgreSQL 9.6 the easy way
- v10, The Best PostgreSQL Yet?
- Postgres is the coolest database – Reason #1: Developers love it!
- Postgres is the coolest database – Reason #2: The License
- Postgres is the coolest database – Reason #3: No vendor lock-in
- Postgres is the coolest database – Reason #4: It is extendable
- Postgres is the coolest database – Reason #5: It can not be bought out
Uncategorized
United Kingdom News
- 2ndQuadrant Italia supports students affected by L’Aquila earthquakes
- Hot Standby User Group (online) – 13 Jan at 1600UTC
- 2ndQuadrant US Launch Party – February 12 New York City – Canceled
- Easier PostgreSQL 9.0 clusters with repmgr
- How not to build PostgreSQL 9.0 extensions on RPM platforms
- EuroPython 2011: “The Python and the Elephant”
- Enterprise Support – The final hurdle for PostgreSQL?
- FLOSS UK Spring Conference
United States News
- Hot Standby User Group (online) – 13 Jan at 1600UTC
- 2ndQuadrant US Launch Party – February 12 New York City – Canceled
- PGEast, Hardware Benchmarking, and the PG Performance Farm
- PostgreSQL Performance and PGWest
- “PostgreSQL 9.0 High Performance” book is out
- PG West talks
- PostgreSQL CommitFest #3 for 9.1 needs you!
- Easier PostgreSQL 9.0 clusters with repmgr
- How not to build PostgreSQL 9.0 extensions on RPM platforms
- Tuning Linux for low PostgreSQL latency
- Hinting at PostgreSQL
- Data generation and hardware quality
- Spring 2011 PostgreSQL Conferences, US/Canada
- The cost of free PostgreSQL publicity
- CHAR (16) – Another conference on the horizon but with a focus on business
- Reducing the postgresql.conf, parameter at a time
- Linux filesystems and PostgreSQL checkpoint benchmarks
- Intel SSD, now off the sh..err, shamed list
User Group
Vik's PlanetPostgreSQL
Webinars
- Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]
- Webinar: Data Integration With PostgreSQL [Follow Up]
- Power of Indexing in PostgreSQL [Webinar Follow-up]
- Introduction to Postgres-BDR [Webinar Follow-up]
- Webinar : Database Security in PostgreSQL [Follow Up]
- Webinar: Banking on Postgres – Financial Application Considerations [Follow up]
- Webinar : Ansible & PostgreSQL [Follow Up]
- Webinar: New Features in Postgres 12 [Follow up]
- Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
- Webinar: You forgot to put the WHERE in DELETE? [Follow Up]
- Webinar: BDR – Latest Features & Updates [Follow Up]
- Webinar: Application Schema Migration [Follow Up]
- Webinar: All you need to know about CREATE STATISTICS [Follow Up]
- Webinar: State of Full Text Search in PostgreSQL 12 [Follow Up]
- Webinar: Identity Columns and Generated Columns in PostgreSQL [Follow Up]
- Webinar: pg_catalog Unveiled! [Follow Up]
- Webinar: Creating Graph Databases in PostgreSQL [Follow Up]
- Webinar: Date/Timestamp types in PostgreSQL [Follow Up]
- Webinar: KNN Indexing in PostgreSQL [Follow Up]
- Security and Compliance with PostgreSQL [Webinar]
- Webinar: MVCC and Vacuum Basics in PostgreSQL [Follow Up]
- Webinar: Collations: Introduction, Features, Problems [Follow Up]
- Webinar: Tuple Freezing & Transaction Wrap around Through Pictures [Follow Up]
- Webinar: Cloud Native BDR and PostgreSQL [Follow Up]
- Webinar: PostgreSQL deployments & TPAexec [Follow Up]
- Webinar: PostgreSQL continuous backup and PITR with Barman [Follow Up]
- Webinar: Understanding the PostgreSQL table page layout [Follow Up]
- Webinar: Fantastic Data Types and Where to Use Them [Follow Up]
- Webinar: PostgreSQL Partitioning Roadmap [Follow Up]
- Migration to PostgreSQL [Webinar]
- Fireside Chat: BDR – Advanced Clustering & Scaling for PostgreSQL [Follow Up]
- Webinar: Enhancing Postgres High Availability [Follow Up]
- Webinar: Being Committed – A Review of Transaction Control Statements 1/3 [Follow Up]
- Webinar: Being Committed – A Review of Transaction Control Statements 2/3 [Follow Up]
- Webinar: Being Committed – A Review of Transaction Control Statements 3/3 [Follow Up]
- Webinar: PostgreSQL on Windows [Follow Up]
- Postgres Vacuuming Through Pictures [Webinar]
- Webinar: Similarity Queries in PostgreSQL [Follow Up]
- Business Intelligence with Window Functions in PostgreSQL [Webinar]
- Webinar: JSON & ARRAY – Contemporary PostgreSQL Data Types [Follow Up]
- Webinar: New Features in PostgreSQL 13 [Follow Up]
- New Features in PostgreSQL 13 [Full Webinar Video]
- Webinar: Highway to Zero Downtime PostgreSQL Upgrades [Follow Up]
- Webinar: Managing and Monitoring PostgreSQL Clusters with OmniDB [Follow Up]
- PostgreSQL Partitioning by Simon Riggs [Full Webinar Video]
- Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up]
- Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up]
