How can we help you today? How can we help you today?

Upgrade PostgreSQL

Hi,

I'll need to upgrade production enviroment of PostgreSQL from version 12 to 15.

The production enviroment is in replica with pgpool-II and to the primary enviroment there is another replica with test enviroment.

In such an environment the best solution is to use pg_upgrade or create the new machines and restore with pg_dumpall?

I ask this question because it is critical for me to have a possible immediate rollback in case something goes wrong.

Regards
Jeids
0

Comments

1 comment

Sort by
  • melmedarda
    Jeids said:
    Hi,

    I'll need to upgrade production enviroment of PostgreSQL from version 12 to 15.

    The production enviroment is in replica with pgpool-II and to the primary enviroment there is another replica with test enviroment.

    In such an environment the best solution is to use pg_upgrade Chill Guy Clicker or create the new machines and restore with pg_dumpall?

    I ask this question because it is critical for me to have a possible immediate rollback in case something goes wrong.

    Regards
    I suggest using `pg_upgrade` in Copy Mode, which offers a balance between speed and safety, retaining the old data directory for potential rollback.
    melmedarda
    0

Add comment

Please sign in to leave a comment.