Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> 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
