Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Tom Lane
=?iso-8859-1?Q?=22Martin_M=FCnstermann=22?= writes: > In case it does not work great, what kind of problems would we experience? In theory pg_control contains enough information to detect such compatibility problems, so that you'd get a refusal to start. In practice, maybe not, and the consequenc

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
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

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Renato Oliveira
: 29 March 2010 11:50 To: Robert Joosten; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Migration of PGDATA 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 RHE

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
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

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Robert Joosten
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/rest

Re: [ADMIN] Migration of PGDATA

2010-03-29 Thread Guillaume Lelarge
Le 29/03/2010 11:31, "Martin Münstermann" a écrit : > [...] > 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 properl

[ADMIN] Migration of PGDATA

2010-03-29 Thread Martin Münstermann
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 neces