Francesco's PlanetPostgreSQL Archives - 2ndQuadrant

PostgreSQL 9.6: Parallel Sequential Scan

July 11, 2016/0 Comments/in Featured, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco Canovai

For a long time, one of the most known shortcomings of PostgreSQL was the ability to parallelise queries. With the release of version 9.6, this will no longer be an issue. A great job has been done on this subject, starting from the commit 80558c1, the introduction of parallel sequential scan, which we will see […]

Automating Barman with Puppet: it2ndq/barman (part three)

April 22, 2015/1 Comment/in Francesco's PlanetPostgreSQL /by Francesco Canovai

In the second part of the Automating Barman with Puppet series we configured, via Puppet, two virtual machines: a PostgreSQL server and a Barman server to back it up. However, human intervention was required to perform the SSH key exchange and most of the manifest was written to allow the servers to access each other. […]

Automating Barman with Puppet: it2ndq/barman (part two)

April 1, 2015/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco Canovai

In the first part of this article we configured Vagrant to execute two Ubuntu 14.04 Trusty Tahr virtual machines, respectively called pg and backup. In this second part we will look at how to use Puppet to set up and configure a PostgreSQL server on pg and back it up via Barman from the backup […]

Automating Barman with Puppet: it2ndq/barman (part one)

March 17, 2015/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco Canovai

This is not the first time that 2ndQuadrant has looked at Puppet. Gabriele Bartolini has already written an article in two parts on how to rapidly configure a PostgreSQL server through Puppet and Vagrant, accompanied by the release of the code used in the example on GitHub (http://github.com/2ndquadrant-it/vagrant-puppet-postgresql).

PostgreSQL 9.4 for administrators (part two)

December 4, 2014/0 Comments/in Francesco's PlanetPostgreSQL /by 2ndQuadrant Press

Written by Francesco Canovai In the previous instalment, we introduced the logical replication feature which has been added to PostgreSQL 9.4. Let’s go on exploring the multitude of new features that version 9.4 brings to the Operation field, easing the management of PostgreSQL databases for system and database administrators. pg_prewarm pg_prewarm is a new extension to […]

PostgreSQL 9.4 for administrators (part one)

November 13, 2014/1 Comment/in Francesco's PlanetPostgreSQL /by 2ndQuadrant Press

Version 9.4 of PostgreSQL, soon to be released, has many innovations for administrators, including the introduction of support for logical replication, which is the first step towards the integration of multi-master replication into core PostgreSQL. In this two-part article we will show you the main new features for administrators; we begin with […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here

PostgreSQL 9.6: Parallel Sequential Scan

Automating Barman with Puppet: it2ndq/barman (part three)

Automating Barman with Puppet: it2ndq/barman (part two)

Automating Barman with Puppet: it2ndq/barman (part one)

PostgreSQL 9.4 for administrators (part two)

PostgreSQL 9.4 for administrators (part one)

Support & Services

Products

Postgres Learning Center

About Us