On Aug 18, 2011, at 5:36 AM, Adarsh Sharma wrote: > Dear All, > > I want some views on the below requirements : > > 1. I have a Postgres DB server with 25 GB database. It has more than 110 > tables. > I am using Postgresql 8.3 on a CentOs. > 2. I have another system laptop that contains the same database but it is for > testing purposes. > > What I want ? If someone inserts some data in the laptop ( same database and > tables as Postgres DB server ) , that data would synk to my Production > Database server. > > I thought the replication would help but it is not necessary that the laptop > is connected to LAN always and if by mistake issue drop command, all goes in > vain . > > PLease guide me some ways or solutions .
So.... to rephrase (and simplify): - you have a main database - you have another database which is a superset of the main database - you want both databases to be able to accept inserts, deletes, etc. - you want to replicate inserts (only?) on the overlapping tables of the second database back to the main database (or do you want bi-directional replication?) - these databases will often not be able to talk to each other It sounds like Buccardo *might* be a solution for you. It allows for multi-master operation, which is what you seem to be looking for. But if you want, say, inserts only to be replicated, and not deletes, you probably need to look into writing your own replication system in your application. If you keep the requirements strict enough it's really not that hard. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
