Comments
Sort by recent activity
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. / comments
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 i...