Postgres 9.6 feature highlight - pg_rewind and timeline switches

2016-04-25 12:45:32 +0000

pg_rewind, a utility introduced in PostgreSQL 9.5 allowing one to reconnect a master to one of its promoted standbys, making unnecessary the need of a new base backup and hence saving a huge amount of time, has gained something new in Postgres 9.6 with the following commit:

Postgres 9.6 feature highlight - Multiple synchronous standbys

2016-04-13 00:15:34 +0000

Among the features that are going to land with Postgres 9.6, here is a nice one that is going to make users in charge of high-availability structures quite happy, in short a lot:

Postgres 9.6 feature highlight - read balancing with remote_apply

2016-04-05 13:01:17 +0000

While the last commit fest of PostgreSQL 9.6 is moving to an end with a soon-to-come feature freeze, here is a short story about one of the features that got committed close to the end of it:

Postgres 9.6 feature highlight - WAL receiver status via SQL

2016-01-09 13:10:22 +0000

Following the recent post related to the extension that gives a representation of a WAL receiver doing WAL recovery via streaming, here is its equivalent in-core, for a new feature that will be available in Postgres 9.6:

Tracking WAL receiver status during replication via SQL

2015-12-11 05:35:22 +0000

In the series of extensions making the life of operators and DBAs easier, and after the facility to easy the tracking of Postgres backend processes waiting for synchronous replication, here is a new feature that has been added to the existing module pg_rep_state aimed at representing at SQL level what shared memory holds for a WAL receiver (a WAL receiver being what is used on a backend receiving WAL in replication from a root node via streaming).

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Next »