Re: Move a database from one server to other - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Move a database from one server to other
Date
Msg-id 0EF35EC9-B48C-42C7-9756-6C4785B4C2C4@seespotcode.net
Whole thread Raw
In response to Re: Move a database from one server to other  ("Nicholas Barr" <nicky@chuckie.co.uk>)
List pgsql-general
On Jun 25, 2007, at 10:44 , Nicholas Barr wrote:

> Only copy the data directory if both servers are offline and not
> running
> and if both servers use the same version of postgres.

... and have the same architecture. As you note, copying the data
directory is *not* the recommended way to do this. Use pg_dump[all]
or something like Slony.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: yet another simple SQL question
Next
From: Adrián Ribao Martínez
Date:
Subject: Re: acampada