Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL Replication with read-only access tostandby DB

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Keaton Adams <kadams(at)mxlogic(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Replication with read-only access tostandby DB
Date: 2008-03-25 22:08:44
Message-ID: (view raw or whole thread)
Lists: pgsql-generalpgsql-hackers
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

  PostgreSQL UK 2008 Conference:

In response to


pgsql-hackers by date

Next:From: Simon RiggsDate: 2008-03-25 22:32:05
Subject: Re: advancing snapshot's xmin
Previous:From: Andrew DunstanDate: 2008-03-25 22:03:39
Subject: Re: gcc 4.3 breaks ContribCheck in 8.2 and older.

pgsql-general by date

Next:From: Richard BroersmaDate: 2008-03-25 22:32:57
Subject: Re: PostgreSQL Replication with read-only access to standby DB
Previous:From: Malinka RellikwodahsDate: 2008-03-25 21:37:00
Subject: Re: select any table

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group