Re: PostgreSQL upgrade.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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






[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux