From: | "Roderick A(dot) Anderson" <raanders(at)cyber-office(dot)net> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Move databases from Pg 7.2.1 to 8.3.x |
Date: | 2009-04-14 18:28:14 |
Message-ID: | 49E4D5BE.6030909@cyber-office.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Joshua D. Drake wrote:
> On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
>> 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).
>
> O.k. :) Don't do it that way.
>
> You want to install the new version of PostgreSQL and use the version of
> pg_dump that comes with that machine.
Thanks Josh.
See my later postings. Quickly I'm using pg_dump from Pg 8.3.4 and I'm
not doing the whole cluster, just selected databases.
> Secondly there is no reasons to do -D (which is actually -d btw). Just
> do a stock pg_dumpall.
>
> Lastly on the new machine you will likely need to create your cluster
> with --no-locale otherwise I can pretty much guarantee the restore won't
> work from that far back. Alternatively you can try to cleanse the data
> with something like iconv.
I'll know pretty soon. :-)
\\||/
Rod
--
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2009-04-14 18:29:17 | Re: pgSql authentication problem with openLdap |
Previous Message | Roderick A. Anderson | 2009-04-14 18:20:13 | Re: Move databases from Pg 7.2.1 to 8.3.x |