Re: PostgreSQL Replication with read-only access to standby DB

On Tue, 2008-03-25 at 14:11 -0600, Keaton Adams wrote:

> “Oracle Active Data Guard enables a physical standby database to be
> open for read-only access – for reporting, simple or complex queries –
> while changes from the production database are being applied to it.
> This means any operation that requires up-to-date read-only access can
> be offloaded to the replica, enhancing and protecting the performance
> of the production database.”
>
> “All queries reading from the physical replica execute in real-time,
> and return current results. A Data Guard configuration consists of
> one production (or primary) database and up to nine standby
> databases. A standby database is initially created from a backup copy
> of the primary database. Once created, Data Guard automatically
> maintains the standby database as a synchronized copy of the primary
> database by transmitting primary database redo data to the standby
> system and then applying the redo data to the standby database.”
>
> Does anyone know of such a solution for PostgreSQL?

Some funding would help that move forwards. If you or others would
consider that, it would help, even if just to provide the seed for
additional contributors.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk