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

2 comments

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
  • walterliz

    It's best to create a new PostgreSQL 15 cluster and migrate the data there (dump/restore or logical replication geometry dash jump). This method is safe, easy to rollback, and doesn't affect the current production environment.

    walterliz
    0

Add comment

Please sign in to leave a comment.