1

How to selectively replicate a PostgreSQL database

view story
linux-howto

http://serverfault.com – I would like to keep two PostgreSQL databases with the same schema, but have one replicated from a master that only keeps a small portion of the live data. The master takes in live data and deletes old data outside of the time window. The replicated slave should keep all the historical data (at least up to the limits of the disk), so in essence, the slave should replicate the master except its deletes. Is this possible with any "off-the-shelf" PostgreSQL replication method? (HowTos)