On 20th of January, Peter Eisentraut committed patch: Logical replication - Add PUBLICATION catalogs and DDL - Add SUBSCRIPTION catalog and DDL - Define logical replication protocol and output plugin - Add logical replication workers From: Petr Jelinek Reviewed-by: Steve Singer Reviewed-by: Andres Freund Reviewed-by: Erik Rijkers Reviewed-by: Peter Eisentraut

There is this idea that from 9.5 we will be able to upgrade pg clusters to newer, major, version, without downtime (well, almost), thanks to magic of logical replication. Sounds very promising, so I figured - I'll test it. To some ...

One of my clients is upgrading some servers. The procedure we have took some time to get to current state, and we found some potential problems, so decided to write more about it.

Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don't actually have 'REINDEX CONCURRENTLY' command - it's a bit tricky. So, since I will be doing ...

On May, 12ve, Bruce Momjian committed new contrib module for 9.0 - pg_upgrage. As I understand - this is what was available before as pg-migrator. If you're not familiar with it - it's a tool that allows upgrade of $PGDATA from some ...