Re: Moving Tablespaces

In article <43BB1FAA(dot)6090001(at)cyberdesk(dot)com>,
Allen Fair <allen(at)cyberdesk(dot)com> wrote:

% Do you or (or anyone else) suggest a method for moving databases from
% one server to another without the time consuming dump/transfer/restore
% process? Anything in the contrib directory or a good management tool?

If you want to transfer an entire server to a different machine (i.e.,
not just a database, but all the databases), you can simply copy the
files, assuming the other machine has the same postgres version and
is architecturally compatible.

Tom's answer refers to mixing table files from one postgres server
with table files from a different postgres server. If you need to
do something like that, the answer is to use replication to move
the data over as it changes.
--

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