Search Postgresql Archives

Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/2/24 14:31, Ron Johnson wrote:
On Mon, Dec 2, 2024 at 5:18 PM Bharani SV-forum <esteembsv-forum@xxxxxxxxx <mailto:esteembsv-forum@xxxxxxxxx>> 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.

Really?

Then this:

https://www.postgresql.org/docs/current/pgupgrade.html

must be random nose.


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux