fel <fell...@hotmail.com> wrote: > I have a small server running RHEL 5.2 32bit / Postgresql 8.3.3. > I would like to upgrade Postgres to 9.0 on a new server running > RHEL 5.5 but 64bit. > > What would be the best solution : > - Dump data from 32bit to 64bit then upgrade to v9.0 (using > pg_upgrade). > - Upgrade to v9.0 then dump from 32 to 64bit. > - Dump from 8.3-32bit to 9.0-64bit. I would use pg_dump executing on the new system (pointing to the old database) and pipe the output directly into psql to populate the new database. -Kevin
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
