Re: Migration of PGDATA - Mailing list pgsql-admin

From Martin Münstermann
Subject Re: Migration of PGDATA
Date
Msg-id 20100329115004.222110@gmx.net
Whole thread Raw
In response to Re: Migration of PGDATA  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Migration of PGDATA
Unknown winsock error 10061
List pgsql-admin
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?
> >
>
> As long as you have the same hardware platform (for example no
> 32bit/64bit changes) and no difference in compiling options (for example
> --disable-integer-datetimes), it should work great.

There is no difference in the platform or the compiler options.

In case it does not work great, what kind of problems would we experience?
Would PG not startup at all? Or would we experience SQL errors later on or even casual crashes?

Thanks,
 Martin


--
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/chbrowser

pgsql-admin by date:

Previous
From: Renato Oliveira
Date:
Subject: Re: Migration of PGDATA
Next
From: ALEXANDER JOSE
Date:
Subject: Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory