Upgrade PostgreSQL

Jeids

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