From: Steve Crawford <scrawford@pinpointresearch.com>
To: Huan Ruan <huan.ruan.it@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Copy one database to another server
Date: Thu, 02 May 2013 15:19:35 -0700
Message-ID: <5182E677.7050104@pinpointresearch.com> (raw)
In-Reply-To: <CAD1stZuo0FyomMg+4HxoGXHnJayP6Bcn=QCngDR_1Asu6zcYQQ@mail.gmail.com>
References: <CAD1stZuo0FyomMg+4HxoGXHnJayP6Bcn=QCngDR_1Asu6zcYQQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 05/02/2013 03:01 PM, Huan Ruan wrote:
> Hi All
>
> We are migrating from Firebird to Postgres. One task we frequently
> perform is to copy one database from one server to another...
I think it would be helpful to know *why* you do this (backup,
forensics, development, shifting load among virtual machines or ???) as
well as a better idea of how often you do this, how long it takes and
the amount of downtime you consider acceptable. That way we may be
better able to come up with a way of solving the actual problem you are
facing.
There are a number of non-core replication solutions such as Slony and
many can migrate a single database or even specific table(s).
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, huan.ruan.it@gmail.com
Subject: Re: Copy one database to another server
In-Reply-To: <5182E677.7050104@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox