Techniques for Recognizing DML Effects?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Techniques for Recognizing DML Effects?
Date: 2003-04-02 00:19:55
Message-ID: 200304011719.55844.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At last glance, some of the current trigger-based asyncronous master-slave
replication tools (dbmirror, rserv, erserver) do not support DML statement
replication. If certain DML statements are executed on a master, say
CREATE TABLE or DROP COLUMN, adjustments must be made on the slave as well.
A warning of such an occurrence would be useful for an administrator.

Is there a simple means of recognizing when a DML statement has occurred on
a cluster strictly by querying system tables? Other ideas as to how to
most easily recognize DML changes in an automated fashion, short of
continually grepping server logs?

Ed

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-04-02 00:21:33 Re: special columns
Previous Message Martijn van Oosterhout 2003-04-02 00:19:49 Re: Postgres logs