Move databases from Pg 7.2.1 to 8.3.x

From: "Roderick A(dot) Anderson" <raanders(at)cyber-office(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Move databases from Pg 7.2.1 to 8.3.x
Date: 2009-04-14 16:58:48
Message-ID: 49E4C0C8.6050303@cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)

The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database on the new system.

I have the time to fiddle about but would appreciate any suggestions to
make it run smooth(er).

\\||/
Rod
--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-04-14 17:21:20 Re: Move databases from Pg 7.2.1 to 8.3.x
Previous Message William Temperley 2009-04-14 16:47:34 Disconnected editing - versioning of databases