Postgres Pro
Downloads
Home   >   mailing lists

Syncing Data to Production DB Server - Mailing list pgsql-general

From Adarsh Sharma
Subject Syncing Data to Production DB Server
Date
Msg-id 4E4D073D.6020909@orkash.com
Whole thread Raw
Responses Re: Syncing Data to Production DB Server
List pgsql-general
Tree view 
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 .


Thanks

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Using Postgresql as application server
Next
From: tamanna madaan
Date:
Subject: Re: idle in transaction process