From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jaime Casanova <jaime@2ndquadrant.com>
Cc: EDH <evandhoffman@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Copying data files to new hardware?
Date: Wed, 13 Oct 2010 13:05:00 -0400
Message-ID: <28873.1286989500@sss.pgh.pa.us> (raw)
In-Reply-To: <AANLkTineQdKs0fBEh0t3BNFDR1QUV9g0eJvSAokeyHb=@mail.gmail.com>
References: <7dc101b1-6596-4850-b0ce-cb3f01f51f14@n40g2000vbb.googlegroups.com>
<AANLkTineQdKs0fBEh0t3BNFDR1QUV9g0eJvSAokeyHb=@mail.gmail.com>
Jaime Casanova <jaime@2ndquadrant.com> writes:
> On Wed, Oct 13, 2010 at 11:03 AM, EDH <evandhoffman@gmail.com> wrote:
>> 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?
> it's safe to just install any version of 8.2.x, copy the whole data
> directory (plus any tablespace's directories you could have) and start
> again...
Not just "any" version --- it has to be the same build options.
(integer-datetimes is definitely a critical option, and I forget what
else.) But if you're using an RPM from the same RPM supplier as before,
they probably got this right.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, jaime@2ndquadrant.com, evandhoffman@gmail.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Copying data files to new hardware?
In-Reply-To: <28873.1286989500@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox