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
--
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
