Postgres Pro
Downloads
Home   >   mailing lists

Upgrade PostgreSQL 9.6 to 10.6 - Mailing list pgsql-general

From github kran
Subject Upgrade PostgreSQL 9.6 to 10.6
Date
Msg-id CACaZr5QTpyJJCxsRb=4a21azHjPygccLqFuGTuqKnvUHkAxW=A@mail.gmail.com
Whole thread Raw
Responses Re: Upgrade PostgreSQL 9.6 to 10.6
List pgsql-general
Tree view
Hello PostgreSQL Team,
I would like to know what would be the best way to do Database migration from PostgreSQL 9.6 engine to 10.6 by creating a new cluster in 10.6 and then copy data.

Size of the cluster is 3.8 TB.

1) It would be a new cluster we want to create on 10.6 and then copy data form 9.6 and shutdown 9.6 
2) Cluster today contains 1 master instance and another instance for reader
3) Can this be done without a downtime ?  what are the options I have to do this without making this complicated . We have about 30 -40 tables to do the migration.

Appreciate your replies.

Thanks,
Kranthi

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: AW: secure deletion of archived logs
Next
From: Andreas Kretschmer
Date:
Subject: Re: Upgrade PostgreSQL 9.6 to 10.6