471,090 Members | 1,357 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

7.3 dump into 7.2 (my solution)


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
0 896

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ravi Tallury | last post: by
2 posts views Thread by Johannes Nix |Johannes.Nix | last post: by
7 posts views Thread by Cyril VELTER | last post: by
5 posts views Thread by Allin Cottrell | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.