Copying data files to new hardware?

From: EDH <evandhoffman(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: Copying data files to new hardware?
Date: 2010-10-13 16:03:17
Message-ID: 7dc101b1-6596-4850-b0ce-cb3f01f51f14@n40g2000vbb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2010-10-13 16:41:55 Re: [GENERAL] Copying data files to new hardware?
Previous Message Josi Perez (3T Systems) 2010-10-13 14:00:19 Re: installation failed for PostgreSQL 9.0.0 in Windows (Visual C++ Runtime Installation error)

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-10-13 16:18:14 Re: pitr question
Previous Message Tom Lane 2010-10-13 15:53:02 Re: pitr question