On Mon, 2020-01-20 at 14:59 +0100, Ekaterina Amez wrote:
> PS: Just in case anyone wants to know, this is part of the process of upgrade a server with 9.2 version
> that has no free space in PGDATA and that can't be stopped for much time. After asking here, the strategy
> to upgrade will be: replicate this DB to a path with space to grow, switch clusters (slave becoming master
> and creating a new slave to have just-in-case), and pg_upgrade slave/new master with --link option.
Do not upgrade to 9.6, upgrade to at least v11.
Set "wal_keep_segments" high enough on the primary for safety.
Run "pg_basebackup" on the standby.
Create a "recovery.conf" on the standby that has "primary_conninfo" set
and "standby_mode = on".
Start the standby and wait until it has caught up, then switch over.
Yours,
Laurenz Albe