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
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) |
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 |