Re: Syncing Data to Production DB Server

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.