Re: record-based log shipping

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: record-based log shipping
Date: 2007-12-08 06:10:28
Message-ID: Pine.GSO.4.64.0712080103590.2976@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 7 Dec 2007, Alex Vinogradovs wrote:

> The documents highlights possible problems with _SQL_ query intercepts.
> I am talking about the actual tuples... i.e. row data rather than the
> SQL requests.

The first two issues that come to mind are how to deal with a) deletions,
and b) changes to DDL (table creation etc.). Forwarding SQL handles those
but I'm not sure how your suggested scheme would. You should certainly
look at what went into the design of both the existing WAL replication and
tools like Slony to get an idea the full scale of challenges here.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Vinogradovs 2007-12-08 06:57:34 Re: record-based log shipping
Previous Message Mason Hale 2007-12-08 04:51:28 partitioned table query question