I have a large Postgres DB (1100 GB) that I'd like to move to a new physical machine. In the past I've done this via pg_dump & restore, but the DB was much smaller then, and I'm concerned about how long that would take. The version of pg currently in use is: PostgreSQL 8.2.5 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-52) What I'd like to know is: if I install the latest 8.2.x release - I see 8.2.18 RPMs are available - can I do a straight copy of the contents of /var/lib/pgsql/data/ to the new server and start it up? Or is dump & restore the only real way to do this? If I have to do a dump & restore I figure I may as well take the opportunity to migrate to 8.4 or 9.0, but I'd rather just get everything done as quickly as possible. Thanks, Evan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
