WAL reader facility

2015-08-10 07:35:44 +0000

Since PostgreSQL 9.3, the code tree is shipping a file named xlogreader.c that contains a set of independent routines that can be used to read and decode WAL records. While it is not available in an independent library, any frontend or backend application can use it at compilation to be able to work on WAL. The code of PostgreSQL uses it already in a couple of places, hence many examples are already available in core to help the development of plugins with this facility:

Postgres 9.6 feature highlight - pg_basebackup and replication slots

2015-07-31 13:55:22 +0000

As the first post dedicated to the feature coverage of Postgres 9.6 which is currently in active development, let’s talk about the following commit:

Minimalistic Docker container with Postgres

2015-07-24 05:24:38 +0000

Docker is well-known, is used everywhere, is used by everybody and is a nice piece of technology, there is nothing to say about that.

Postgres 9.5 feature highlight - pg_file_settings to finely track system configuration

2015-07-15 07:47:33 +0000

PostgreSQL 9.5 is coming up with a new feature aimed at simplifying tracking of GUC parameters when those are set in a multiple set of files by introducing a new system view called pg_file_settings:

Postgres 9.5 feature highlight - New missing_ok option for file access functions

2015-07-05 12:44:33 +0000

Finding its origin as a fix for [pg_rewind] (https://www.postgresql.org/docs/devel/static/app-pgrewind.html) where rewind process could fail if a file marked as listed in the source server was removed before fetching its data (see more details here, this could impact temporary files or relation file for example), here is a small feature of PostgreSQL 9.5 that may be useful for application developers:

« 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 »