Historically, PostgreSQL’s replication configuration has been managed via a configuration parameters stored in a dedicated configuration file, recovery.conf, which has been present in PostgreSQL since the introduction of archive recovery in PostgreSQL 8.0. One of the major changes in PostgreSQL 12, co-authored by 2ndQuadrant is the replacement of recovery.conf and the conversion of recovery.conf parameters […]
+39 0574 159 3000
Barman 2.10 – Recovery of partial WAL files
/0 Comments/in Anna's PlanetPostgreSQL /by Anna BellandiBeing a PostgreSQL database administrator and managing backups on a daily basis, one of the new features of Barman 2.10 that I liked the most is the transparent management of .partial WAL files during recovery. And, most likely, you feel the same if you have been using Barman with WAL streaming and have been asked […]
Setting SSL/TLS protocol versions with PostgreSQL 12
/2 Comments/in 2ndQuadrant, Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter EisentrautPostgreSQL 12 contains two new server settings: ssl_min_protocol_version ssl_max_protocol_version As the names indicate, these are used to control the oldest (minimum) and newest (maximum) version of the SSL and TLS protocol family that the server will accept. (For historical reasons, in PostgreSQL, all settings related to SSL and TLS are named ssl_something, even though TLS […]
Webinar: Using SSL with PostgreSQL and pgbouncer [Follow Up]
/0 Comments/in 2ndQuadrant, Webinars /by Liaqat AndrabiSecuring data in motion is a necessity in today’s world. PostgreSQL provides a way to encrypt and authenticate communication by using a Secure Sockets Layer or SSL protocol. 2ndQuadrant hosted a webinar to give an introduction on using SSL, encryption and authentication methods, and how to successfully configure and deploy SSL with PostgreSQL. The webinar […]
PostgreSQL 12: Implementing K-Nearest Neighbor Space Partitioned Generalized Search Tree Indexes
/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk RoybalK-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.
Webinar: PostgreSQL Partitioning [Follow up]
/1 Comment/in 2ndQuadrant, PostgreSQL, Webinars /by Bilal IbrarWith the recent release of PostgreSQL 12, there’s been a lot of interest in the latest version and by popular demand, the team at 2ndQuadrant organized a live webinar on “PostgreSQL Partitioning”. The webinar was hosted by Simon Riggs, CTO 2ndQuadrant, who gave an overview of PostgreSQL partitioning features and how they play a key […]
Postgres-BDR: It is also about fast safe upgrades
/2 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom KincaidIn the past year, I have had many conversations with many clients and prospects about Postgres-BDR. For those of you who don’t know this Postgres-BDR has been in production for many mission critical deployments for quite some time. We have more clients coming on board each month. Most recently, I have been meeting with […]
Managing another PostgreSQL Commitfest
/0 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherreI have written about managing a PostgreSQL commitfest before. During the PostgreSQL 13 development cycle, I did it again. This time I used a different strategy, mostly because I felt that there was excessive accumulation of very old patches that had received insufficient attention. So apart from bugfixes (which are always special cases), I focused […]
PostgreSQL 12: Foreign Keys and Partitioned Tables
/4 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by alvherreNow that PostgreSQL 12 is out, we consider foreign keys to be fully compatible with partitioned tables. You can have a partitioned table on either side of a foreign key constraint, and everything will work correctly. Why do I point this out? Two reasons: first, when partitioned tables were first introduced in PostgreSQL 10, they […]
A convenient way to launch psql against postgres while running pg_regress
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerI got tired of looking up regression_output/log/postmaster.log to find the PGSOCKET to use to connect to a running pg_regress‘s temp-install postgres so I wrote a little shell function for it. My patch to print a connst in pg_regress never got merged so I needed a workaround. I’m sure I’m not the only one, so here’s […]
Replication configuration changes in PostgreSQL 12
/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian BarwickHistorically, PostgreSQL’s replication configuration has been managed via a configuration parameters stored in a dedicated configuration file, recovery.conf, which has been present in PostgreSQL since the introduction of archive recovery in PostgreSQL 8.0. One of the major changes in PostgreSQL 12, co-authored by 2ndQuadrant is the replacement of recovery.conf and the conversion of recovery.conf parameters […]