I used pg_dump v 8.3.4, but I could rerun using v9.0.1. I was thinking that pg_dump v9 would refuse to play right with
thev8 DB. Is that a false assumption?
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Wednesday, November 23, 2011 11:48 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dump of a v8.3.4 -> v9.0.1
On 11/23/2011 08:08 AM, Gauthier, Dave wrote:
> Hi:
>
> I have a pg_dump pf a v8.3.4 DB that I would like to bring into a v9.0.1
> PG instance. What is the best way to do this? Note, the dump file is too
> big to fit into an editor, but I could sed it if need be.
Did you do the data dump using the 8.3.4 version of pg_dump or the 9.0.1?
If you used the newer version the dump format should not cause you any
problems. What you will need to do is read the release notes for the
version 8.4 and 9.0 for any changes that may affect your data once it is
in the database.
>
> Thanks.
>
--
Adrian Klaver
adrian.klaver@gmail.com
