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

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 migration:
    Dump/restore
    Replication
    Etc

3) How are you installing Postgres:
    Ubuntu repos
    Postgres community repos

4) Location of one machine relative to other

5) Time frame to do migration.

> 
> Thanks,
> venkatesh.


-- 
Adrian Klaver
adrian.klaver@aklaver.com