| From: | Thorsten Schöning <tschoening(at)am-soft(dot)de> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: upgrade path from PG 8.3 to PG 9.5 |
| Date: | 2017-03-21 16:25:24 |
| Message-ID: | 722763388.20170321172524@am-soft.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Guten Tag Keith,
am Donnerstag, 23. Februar 2017 um 18:57 schrieben Sie:
> You can go directly from 8.3 to 9.5. Just be sure and use the
> pg_dump from 9.5 to generate the dump file from 8.3.
Is there a specific reason for that? My current approach for upgrades
was dumping the old database using the old pg_dump, uninstalling the
old Postgres, installing the new one and restore from the old dump.
That way I didn't accidently mix-up installations or use wrong tools
or such.
Did pg_dump have bugs in the past which resulted in pg_restore not
being able to read the dumps?
Mit freundlichen Grüßen,
Thorsten Schöning
--
Thorsten Schöning E-Mail: Thorsten(dot)Schoening(at)AM-SoFT(dot)de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/
Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04
AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2017-03-21 16:40:49 | Re: upgrade path from PG 8.3 to PG 9.5 |
| Previous Message | Poul Kristensen | 2017-03-21 13:44:47 | Re: Postgres - Replication |