| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Upgrade PostgreSQL 9.6 to 10.6 |
| Date: | 2019-12-09 16:02:02 |
| Message-ID: | b9a95844-ff64-e5dd-9194-f207499c9b57@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 09.12.19 um 16:43 schrieb github kran:
> 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.
>
>
yes, you can use pg_logical from us (2ndquadrant). Please visit our
homepage, there you can find it for 9.6. There are also some
blogs-postings about all that in our blog.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albrecht Dreß | 2019-12-09 17:30:09 | Re: Q: cert authentication and user remapping fails |
| Previous Message | github kran | 2019-12-09 15:43:48 | Upgrade PostgreSQL 9.6 to 10.6 |