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