Re: Move a database from one server to other

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: nicky(at)chuckie(dot)co(dot)uk
Cc: Adrián Ribao Martínez <aribao(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Move a database from one server to other
Date: 2007-06-25 19:07:03
Message-ID: 0EF35EC9-B48C-42C7-9756-6C4785B4C2C4@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Hevia 2007-06-25 19:20:37 NO DATA FOUND Exception
Previous Message Erik Jones 2007-06-25 19:03:58 Re: yet another simple SQL question