Re: pg_dump of a v8.3.4 -> v9.0.1

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump of a v8.3.4 -> v9.0.1
Date: 2011-11-23 16:50:00
Message-ID: 482E80323A35A54498B8B70FF2B8798004D606A825@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com]
Sent: Wednesday, November 23, 2011 11:48 AM
To: Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-11-23 16:52:43 Re: pg_dump of a v8.3.4 -> v9.0.1
Previous Message Adrian Klaver 2011-11-23 16:48:25 Re: pg_dump of a v8.3.4 -> v9.0.1