Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

synchronization Between two Servers Postgres Database

I have two postgres database in different linux server, the thing is that I want to synchronize all the data which are inserted , updated, deleted in SERVER A to SERVER B. Is there any way to do this....? Any one help me ...?

like image 923
Pavunkumar Avatar asked Jun 17 '11 12:06

Pavunkumar


2 Answers

Since 9.0 PostgreSQL supplies it own replication. If you use 8.x you can try other solutions. Personally I used slony and was quite pleased with it.

like image 135
mihn Avatar answered Sep 19 '22 02:09

mihn


There are many options...

like image 43
Denis de Bernardy Avatar answered Sep 22 '22 02:09

Denis de Bernardy