Re: pg_upgrade question

2021-12-02 Thread Alan Stange
Of course that would be in the manual ;-)   Thank you for pointing this out.   We've been doing upgrades the reliable old school way for so long that I wasn't aware that something better was already well documented. Thank you, Alan On 12/2/21 11:10, Adrian Klaver wrote: > On 12/2/21 08:05, Alan

Re: pg_upgrade question

2021-12-02 Thread Adrian Klaver
On 12/2/21 08:05, Alan Stange wrote: Hello all, We're running a 13.x installation and looking to upgrade to 14.1.  This is all on Linux servers.   We have a main instance running with a number of hot standby replicas configured.   In the past, we have done a dump/restore on a slow evening and th

pg_upgrade question

2021-12-02 Thread Alan Stange
Hello all, We're running a 13.x installation and looking to upgrade to 14.1.  This is all on Linux servers.   We have a main instance running with a number of hot standby replicas configured.   In the past, we have done a dump/restore on a slow evening and then rsynced all the bits around so that

Re: pg_upgrade question

2020-12-22 Thread Paul Förster
Hi Dan, > I am trying to find out if there is any step by step instruction to reconcile > old data dir and upgraded data dir after using “—link” option to do an > upgrade. > > I ran this to do an upgrade from 11.5 to 12.1: pg_upgrade -d > /hostname/pg/dev115/data -D /hostname/pg/dev121upg/dat

pg_upgrade question

2020-12-21 Thread Lu, Dan
Hi PostgreSQL Admin, I am trying to find out if there is any step by step instruction to reconcile old data dir and upgraded data dir after using "-link" option to do an upgrade. I ran this to do an upgrade from 11.5 to 12.1: pg_upgrade -d /hostname/pg/dev115/data -D /hostname/pg/dev121upg/data