From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Postgresql 7.4 migration to (partially) new disks
Date: Sun, 17 Sep 2006 11:57:57 +0300
Message-ID: <200609171157.58083.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <24624.1158331639@sss.pgh.pa.us>
References: <200609151344.34058.achill@matrix.gatewaynet.com>
<200609151725.24976.achill@matrix.gatewaynet.com>
<24624.1158331639@sss.pgh.pa.us>
Στις Παρασκευή 15 Σεπτέμβριος 2006 17:47, ο/η Tom Lane έγραψε:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> writes:
> > What considerations should someone take if he is about to just
> > cp -r <path_to_some_other_pgsql_data_path>/data .
> > .i.e. creating the PGDATA dir *not* following the standard initdb
> > procedure
>
> If you copy the *entire* data tree (data, xlog, clog, any outside
> tablespaces), and use exactly the same Postgres executables at both
> ends, then it should pretty much Just Work.
>
Thats what i feared from the begining. (some connection between the data dir
and the executable, really, why does the executable need to be exactly the
same,
if we are talking about minor postgresql upgrade 7.4.12->7.4.13?)
The old system is kind of old, and there would be libraries
incompatibilities if a was to retain the old executable.
So i'll do it the formal way, and pray lotus notes will behave :)
Thanx.
> > chown -R postgres:postgres ./data
> > (new postgres user on the new SUSE might have a different uid/gid than
> > the original Debian),
>
> This is OK.
>
> > I'd suppose this might work on a test system, but should someone
> > rely on it for a critical production system?
>
> As long as the DBA has practiced beforehand ;-), sure.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
--
Achilleas Mantzios
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: achill@matrix.gatewaynet.com, tgl@sss.pgh.pa.us
Subject: Re: Postgresql 7.4 migration to (partially) new disks
In-Reply-To: <200609171157.58083.achill@matrix.gatewaynet.com>
References: <200609151344.34058.achill@matrix.gatewaynet.com> <200609151725.24976.achill@matrix.gatewaynet.com> <24624.1158331639@sss.pgh.pa.us> <200609171157.58083.achill@matrix.gatewaynet.com>
* 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