automation Archives - 2ndQuadrant

Posts

Back to the Future Pt. 1: Introduction to pg_rewind

September 12, 2016/14 Comments/in 2ndQuadrant, Featured, Giuseppe's PlanetPostgreSQL /by 2ndQuadrant Press

Since PostgreSQL 9.5, pg_rewind has been able to make a former master follow up a promoted standby although, in the meantime, it proceeded with its own timeline. Consider, for instance, the case of a switchover that didn’t work properly. Have you ever experienced a "split brain" during a switchover operation? You know, when the goal […]

Code coverage stats

April 18, 2016/0 Comments/in Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro Herrera

Many years ago, Michelle Caise submitted a patch to generate code coverage reports for the PostgreSQL code base, based on the lcov utility. Although I cannot find any record of an actual patch in the mailing list archives, Peter Eisentraut committed it some time later, and applied further refinements later. Today I’m announcing a new […]

PostgreSQL Planet in Ansible Galaxy

January 27, 2016/0 Comments/in 2ndQuadrant, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

Ansible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content!

Ansible Loves PostgreSQL

October 19, 2015/7 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

Ansible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together!

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).

Postgres and devops: testing 9.3 with Vagrant and Puppet – part two

November 4, 2013/2 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

In a previous blog post, I have gone through the steps of setting up a basic CentOS 6.4 64bit Linux distribution using Vagrant on your Ubuntu 12.04 LTS Linux. We will continue digging in the devops culture/movement and finally setup PostgreSQL 9.3 using Puppet in a local virtual machine.

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

Posts

Back to the Future Pt. 1: Introduction to pg_rewind

Code coverage stats

PostgreSQL Planet in Ansible Galaxy

Ansible Loves PostgreSQL

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

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

Postgres and devops: testing 9.3 with Vagrant and Puppet – part two

Support & Services

Products

Postgres Learning Center

About Us