From: "Martin Münstermann" <mmuenst@gmx.de>
To: Robert Joosten <robert@ml.erje.net>
To: pgsql-admin@postgresql.org
Subject: Re: Migration of PGDATA
Date: Mon, 29 Mar 2010 12:49:55 +0200
Message-ID: <20100329104955.222110@gmx.net> (raw)
In-Reply-To: <20100329101857.GC1188@ismet.erje.net>
References: <20100329093134.62810@gmx.net>
<20100329101857.GC1188@ismet.erje.net>
Hi,
> > is it safe to move the PGDATA directory from one system to another when
> migrating from one operating system to another?
> > For example: migrating from Debian to RHEL, or from RHEL4 to RHEL5?
> > The database is of course shutdown properly, and the PG major versions
> match.
> > Or is a dump/restore necessary in these cases?
>
> Besides the other reply, take into account little- versus bigendian
> changes if you switch hardware.
Good point. But as we stick to Linux on Intel, we expect no problems there.
> But just out of curiosity: why propose against a dump/restore ? I mean:
> when I upgrade between major releases I dump as well, as it is
> recommended. I never ran into trouble, you know.
It's a question of migration duration aka downtime.
Our PGDATA resides on a SAN, so moving/migrating the directory takes a couple of seconds. A dump/restore cycle would take much longer.
Thanks,
Martin
--
GMX.at - Österreichs FreeMail-Dienst mit über 2 Mio Mitgliedern
E-Mail, SMS & mehr! Kostenlos: http://portal.gmx.net/de/go/atfreemail
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: mmuenst@gmx.de, robert@ml.erje.net
Subject: Re: Migration of PGDATA
In-Reply-To: <20100329104955.222110@gmx.net>
* 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