Re: Query reg. postgresql 9.6 migration from ubuntu 16.04 to 18.04

2019-05-29 Thread a venkatesh
Thanks your response. Please check the following details. 1) Size of Postgres cluster. A. The number of nodes per cluster are 3 - 1 pgmaster, 1 pgslave and 1 pgpool. There are clusters of multiple sizes - 500 GB, < 500 GB and a few higher than that. 2) Method of migration: Dump/restore

Re: Query reg. postgresql 9.6 migration from ubuntu 16.04 to 18.04

2019-05-22 Thread Adrian Klaver
On 5/22/19 5:03 PM, a venkatesh wrote: Hi, I'm working on migrating postgresql 9.6 database from ubuntu 16.04 to 18.04. Please let me know if there are any document references and best practices that can be followed. Advice is going to depend on: 1) Size of Postgres cluster. 2) Method of m