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