On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum <esteembsv-fo...@yahoo.com> wrote:
> Team > Pl Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver > 15.X > > Env = EC2 based Community PostgreSQL Ver 13.16.2 > > we will be performing upgrade of our EC2 server too along with new OS. > > Need help in vetting my steps for Postgres DB upgrade from Ver 13.X to > ver 15.X > > *ASIS-existing server = EC2 with Community PostgreSQL Ver 13.16.2* > - ensure to capture all the pre.req meant for ver 15.10 are being met. > - shutdown db. > - take offline full backup (PG_DATA folder alone) using OS command > > *Proposed-new EC2 server (with new Operating System version along Postgres > Ver 15.10 Binaries)* > - install postgres 15.10 binaries > - ensure to DISABLE auto startup and shutdown of postgres 15.10 > - Restore offline full backup (PG_DATA folder alone) using OS command > - start performing pg_upgrade step to upgrade postgres from ver 13.16.2 > to 15.10 > > please guide me, if i have missed any steps in the abovesaid process > > To start new DB features, planning to rollout out the following feature's > alone > a) TLE extension for password compliance > b) parallelize vacuum jobs to utilize -j option > To migrate from one server to another while upgrading, one must use pg_dump/pg_restore OR Logical Replication. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!