[GENERAL] DB replication

[Differentiated Software Solutions Pvt. Ltd.]

Hi,

We have an application which has databases in 2 different machines.
The databases are small (25 MB).

Every 15 minutes we want DB of one machine to be synced with another
machine. Are there ready made utilities in postgres to do this.
One way is to take a pgdump, tar it, ftp it and then restore it into the
other machine.
This has a problem if I want to sync selected tables. Also this means the
entire data gets reloaded, whereas only the incremental changes should get
dumped.

Any help is appreciated.

Murali

Differentiated Software Solutions Pvt. Ltd.,
176, Gr. Floor, 6th Main
2nd Block RT Nagar
Bangalore - 560 032
India
Ph: 91 80 3431470
email : diffs+AEA-vsnl.com
http://www.diffs-india.com