Re: PITR Based replication ... - Mailing list pgsql-admin

From Thomas F. O'Connell
Subject Re: PITR Based replication ...
Date
Msg-id A7A23FD9-A2AD-4B37-AE0B-8D63A8479BE8@sitening.com
Whole thread Raw
In response to PITR Based replication ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: PITR Based replication ...  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote:

> I know ppl are using it to do replication, but has anyone
> documented what is involved in doing so?
>
> thanks ...

I'll be curious to hear stories of people using it for replication.
The way I interpret replication, there's an available database (even
if read-only) on both ends. With PITR/on-line backups, the way I
understand it, there's no way to provide availability to the recovery
database because it's in a process of continuous recovery. It
qualifies as high availability in terms of a failover solution, but
the recovery database is not actually available until something
triggers it to recover, at which point any writing done to it causes
it to cease to be a replicant of the base database.

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)

pgsql-admin by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: PITR Based replication ...
Next
From: Jeff Frost
Date:
Subject: Re: PITR Based replication ...