Re: Postgresql 7.4 migration to (partially) new disks

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)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.

> 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