[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] 7.3 dump into 7.2 (my solution)
From:       Russ Schneider <russ () sugapablo ! com>
Date:       2003-12-30 19:54:27
Message-ID: Pine.LNX.4.50.0312301453010.5545-100000 () dell ! sugapablo ! net
[Download RAW message or body]


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@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
[prev in list] [next in list] [prev in thread] [next in thread]