Re: PostgreSQL upgrade.

Andreas Kretschmer <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <[email protected]> 

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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.