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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general