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

7.3 dump into 7.2 (my solution)

P: n/a

On Fri, 26 Dec 2003, Russ Schneider wrote:
I need to transfer a dump from a psql 7.3 database to a 7.2 database.

Is there any way to do this?


In case anyone wants to know (or find out later searching the archives), I
was able to do this with minimal effort.

Here's what worked for me:

1) pg_dumpall the 7.3 DBs using the --inserts clause.

2) Do a search and replace in the dumpfile, replacing
"pg_catalag.setval" with just "setval".

3) Comment out all the lines at the beginning that create the
databases themselves.

4) In 7.2, create the databases you need via the command line.

5) Dump the file back into 7.2.

--
[ 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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.