Posts by: giuseppe.broccolo

Back to the Future Part 3: pg_rewind with PostgreSQL 9.6

backtothefuture_03

This is the third and last part of blog articles dedicated to pg_rewind. In the two previous articles we have seen how pg_rewind is useful to fix split-brain events due to mistakes in the switchover procedures, avoiding the need of new base backups. We have also seen that this is true for simple replication clusters,…

Back to the Future Pt. 2: How to use pg_rewind with PostgreSQL 9.5

backtothefuture_02

In the previous blog article we have seen how pg_rewind works with a simple HA cluster, composed of a master node replicating to a standby. In this context, an eventual switchover involves just two nodes that have to be aligned. But what happens with HA clusters when there are several (also cascading) standbys? Now, consider…

Back to the Future Pt. 1: Introduction to pg_rewind

BacktotheFuture_01

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…

BRIN for PostGIS: my story at the Code Sprint 2016 in Paris

25114331182_92bc5ebab3_q

Last week I was pleased to attend Code Sprint 2016 in Paris, organised by the OSGeo Foundation: it has been an opportunity for many GIS users from all over the world to get together, discuss and actively work on many open tasks of some of the major open source frameworks on GIS. PostGIS was obviously…

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

within-group-and-filter

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses that facilitate many operations required during the development of applications: the WITHIN GROUP and FILTER clauses.

NoSQL with PostgreSQL 9.4 and JSONB

slide-json-giuseppe

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQ” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer a data structure in a “key-value” array, dictionary style (widely used in the field of development) and, at the same time, ensures all the advantages…