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 ]
[ sugapablo(at)12jabber(dot)com <--jabber IM ]