Thread: Save postgresql node to catch only DML except delete queries
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.
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
Any idea? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Save-postgresql-node-to-catch-only-DML-except-delete-queries-tp5753603p5753863.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.