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 the v8 DB. Is that a false assumption? -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Wednesday, November 23, 2011 11:48 AM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
