Am 10.04.19 um 07:40 schrieb Daulat Ram:
We have two node postgresql database version 9.6 with streaming replication which is running on docker environment, os Linux (Ubuntu) and we have to migrate on PostgresQL11. I need your suggestions & steps to compete the upgrade process successfully.
there are exists several ways to do that. You can take a normal dump and replay it in the new version, you can use pg_upgrade, and you can use a logical replication (using slony, londiste or pg_logical from 2ndQuadrant). There is no 'standard way' to do that, all depends on your requirements and knowledge how to work with that tools.
Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com
