Re: Save postgresql node to catch only DML except delete queries - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Save postgresql node to catch only DML except delete queries
Date
Msg-id 87y5bytxo7.fsf@comcast.net
Whole thread Raw
In response to Save postgresql node to catch only DML except delete queries  (roshan2013 <codevally@gmail.com>)
List pgsql-general
roshan2013 <codevally@gmail.com> writes:

> 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?

Suggest you research logical replication solution such as Slony or
SkyTools.

You wil need to implement your own row firing triggers on  archiving
tables such that delets are a no-op.

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

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


pgsql-general by date:

Previous
From: Steven Schlansker
Date:
Subject: Re: Simple SQL INSERT to avoid duplication failed: why?
Next
From: Merlin Moncure
Date:
Subject: Re: zLinux Load Testing Experience