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: 1206482924.4285.1077.camel@ebony.site (view raw or flat)
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
  2ndQuadrant  http://www.2ndQuadrant.com 

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


In response to

Responses

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-2014 The PostgreSQL Global Development Group