PostgreSQL Buildfarm client Release 6 is now available and can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-6.tgz Features use a persistent cache for configure, leading to a substantial performance improvement for that step, based on an idea from Tom Lane improve installcheck security, mirroring earlier changes on this in Postgres itself allow skipping individual TAP tests, e,g, “–skip_steps=pg_dump-check” a […]
PG Phriday: Adventures in BAR Management
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasBackups are a critical component to a fully covered Postgres database infrastructure. In some ways, it’s fair to say a database without a backup is no database at all—sometimes literally. 2ndQuadrant’s Barman tool is aptly named as a Backup And Recovery Manager for Postgres, and it exists primarily for encouraging a stable and robust backup […]
PostgreSQL Meltdown
/2 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsSpectre and Meltdown have caused severe alarm in recent days. You may have read about up to 30% impact on PostgreSQL databases, which I believe to be overstated because of misunderstandings in the media. Let’s dig into this in more detail. TL;DR Summary: no PostgreSQL patch required, -7% performance hit In response to these new […]
PostgreSQL is the DBMS of the Year 2017
/2 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsThe annual DBEngines ranking have just been updated, with PostgreSQL winning the “DBMS of the Year 2017” award. http://db-engines.com/en/blog_post/76 PostgreSQL was a runner up last year. http://db-engines.com/en/blog_post/67 So across the year, we have made more gains in popularity than all other databases. Looking at the detail we see that all of the other 4 databases […]
Buildfarm Client Bugfix Release 6.1
/1 Comment/in Andrew's PlanetPostgreSQL /by Andrew DunstanI have released version 6.1 of the PostgreSQL Buildfarm client. It is available at http://buildfarm.postgresql.org/downloads/releases/build-farm-6_1.tgz This release fixes a couple of bugs that became apparent in yesterday’s release. The first was a relatively minor one where the verbosity was always set if using the run_branches.pl script. The second was a portability issue where some versions […]
Announcing Release 6 of PostgreSQL Buildfarm client
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanPostgreSQL Buildfarm client Release 6 is now available and can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-6.tgz Features use a persistent cache for configure, leading to a substantial performance improvement for that step, based on an idea from Tom Lane improve installcheck security, mirroring earlier changes on this in Postgres itself allow skipping individual TAP tests, e,g, “–skip_steps=pg_dump-check” a […]
PG Phriday: Postgres on ZFS
/22 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasZFS is a filesystem originally created by Sun Microsystems, and has been available for BSD over a decade. While Postgres will run just fine on BSD, most Postgres installations are historically Linux-based systems. ZFS on Linux has had much more of a rocky road to integration due to perceived license incompatibilities. As a consequence, administrators […]
Webinar: Introduction to JSON data types in PostgreSQL [Follow Up]
/0 Comments/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat AndrabiOn 12-Dec-2017, 2ndQuadrant held the first in a series of PostgreSQL webinars. The session was conducted by Andrew Dunstan, Principal Contributor of JSON functionality to PostgreSQL and Senior Developer & PostgreSQL Committer at 2ndQuadrant. As promised, the recording of the Webinar is now available. Those who couldn’t make it to the live session, can now view Introduction […]
pglogical 2.1 and Logical Replication in PostgreSQL 10
/11 Comments/in Petr's PlanetPostgreSQL /by Petr JelinekOne of the headline features of the brand new PostgreSQL release out 2 months ago is Logical Replication. Logical replication allows more flexibility than physical replication, including replication between different major versions of PostgreSQL and selective-table replication. You can get more details on the feature here. So, now that we have this, I’ve been asked […]
PG Phriday: Getting RAD with Docker [Part 4]
/5 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasPgBouncer is a popular proxy and pooling layer for Postgres. It’s extremely common to reconfigure PgBouncer with repmgr so it always directs connections to the current primary node. It just so happens our emerging Docker stack could use such a component. In our last article, we combined Postgres with repmgr to build a Docker container […]
PostgreSQL 11 – Server-side Procedures (Part 1)
/12 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidLast week marked a rather big step in the PostgreSQL world that went largely unnoticed. Thanks to the work done by 2ndQuadrant contributors, we now have the ability to write Stored Procedures in PostgreSQL! (Ok, well not exactly now but we will have the ability once PostgreSQL 11 comes out) A procedure is essentially a […]