By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

dump 7.3 into 7.2?

P: n/a
I need to transfer a dump from a psql 7.3 database to a 7.2 database.

Is there any way to do this?

--
[ Russ Schneider (a.k.a. Sugapablo) ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ su*******@12jabber.com <--jabber IM ]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Russ Schneider <ru**@sugapablo.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

Nov 12 '05 #2

P: n/a

Tom,

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

Jason
-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.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 <ru**@sugapablo.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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.