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
