Re: postgresql replication - Mailing list pgsql-general

From Scott Marlowe
Subject Re: postgresql replication
Date
Msg-id 1115304751.3868.35.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: postgresql replication  (Vlad <marchenko@gmail.com>)
List pgsql-general
On Wed, 2005-05-04 at 21:06, Vlad wrote:
> the number one aim at the moment is to have "always-up-to-date" copy
> of our main DB with minial performance impact on replication

Have you considered point in time recovery as implemented in 8.0?

While it does require some small amount of work to bring the secondary
server up to date, it's not that much, and it gives you very up to date
recoverability.

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Inserting a record into another table ... inside a schema
Next
From: Tom Lane
Date:
Subject: Re: Postgres, tablespaces, and quotas