Move databases from Pg 7.2.1 to 8.3.x - Mailing list pgsql-general

From Roderick A. Anderson
Subject Move databases from Pg 7.2.1 to 8.3.x
Date
Msg-id 49E4C0C8.6050303@cyber-office.net
Whole thread Raw
Responses Re: Move databases from Pg 7.2.1 to 8.3.x
Re: Move databases from Pg 7.2.1 to 8.3.x
List 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
--

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Move databases from Pg 7.2.1 to 8.3.x