Save postgresql node to catch only DML except delete queries

From: roshan2013 <codevally(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Save postgresql node to catch only DML except delete queries
Date: 2013-04-29 02:55:47
Message-ID: 1367204147034-5753603.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I want to keep one slave node along with our production master server, but
that slave node only accept all the DML except Delete queries.

Primary purpose of this slave node is to keep all the data inserted to the
primary database and no need to delete any data from that.

Anybody know how to achieve this by using postgresql in-built support or
using any tool?

Thanks

/Pradeep.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Save-postgresql-node-to-catch-only-DML-except-delete-queries-tp5753603.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2013-04-29 07:02:31 Re: Implementing DB2's "distinct" types
Previous Message CR Lender 2013-04-28 22:14:15 Re: Checking for changes in other tables