| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL upgrade. |
| Date: | 2019-04-10 08:20:58 |
| Message-ID: | 7e7a988f-0493-8741-199e-529eb68a4d3e@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunther | 2019-04-14 20:23:34 | Out of Memory errors are frustrating as heck! |
| Previous Message | Laurenz Albe | 2019-04-10 08:16:50 | Re: Commit(?) overhead |