Re: Move a database from one server to other

In article <24916(dot)62(dot)244(dot)190(dot)66(dot)1182786241(dot)squirrel(at)www(dot)chuckie(dot)co(dot)uk>,
Nicholas Barr <nicky(at)chuckie(dot)co(dot)uk> wrote:

% Only copy the data directory if both servers are offline and not running
% and if both servers use the same version of postgres. This method is not
% recommended AFAIK.

It _is_ recommended for setting up a warm-standby server (it's the only way).

I copy database clusters around all the time. If the database is shut down,
there's no harm in it and it's usually faster and always simpler than
dump/restore. Copying a snapshot of a running system only has a teenly
little bit of harm in it and you don't even have to shut down the db.
--

Patrick TJ McPhee
North York Canada
ptjm(at)interlog(dot)com