Message-ID: <5182E677.7050104@pinpointresearch.com>
Date: Thu, 02 May 2013 15:19:35 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/20130404 Thunderbird/17.0.5
MIME-Version: 1.0
To: Huan Ruan <huan.ruan.it@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Copy one database to another server
References: 
 <CAD1stZuo0FyomMg+4HxoGXHnJayP6Bcn=QCngDR_1Asu6zcYQQ@mail.gmail.com>
In-Reply-To: 
 <CAD1stZuo0FyomMg+4HxoGXHnJayP6Bcn=QCngDR_1Asu6zcYQQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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