Re: dump 7.3 into 7.2?

From: "Ausrack Webmaster" <webmaster(at)ausrack(dot)com(dot)au>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'pgsql-general'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: dump 7.3 into 7.2?
Date: 2003-12-27 05:32:55
Message-ID: 002601c3cc3a$e241fa10$0100a8c0@jason
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom,

Do you know if it is possible to upgrade postgresql on a RAQ4?

Jason

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Saturday, December 27, 2003 1:09 PM
To: Russ Schneider
Cc: pgsql-general
Subject: Re: [GENERAL] dump 7.3 into 7.2?

Russ Schneider <russ(at)sugapablo(dot)com> writes:
> I need to transfer a dump from a psql 7.3 database to a 7.2 database.
> Is there any way to do this?

You will have to do some manual hacking on the schema declarations,
almost certainly. I'd recommend dumping the schema and data separately
so that the schema file is small enough to edit manageably. Once you
have a schema that loads into the 7.2 database, the data should follow
easily.

[ tries, and fails, to avoid making this comment... ] Your time would
probably be more profitably invested on updating the 7.2 installation to
7.3. See the 7.3 release notes for reasons why.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-12-27 06:44:54 Re: Strange permission problem regarding pg_settings
Previous Message Tom Lane 2003-12-27 04:09:29 Re: dump 7.3 into 7.2?