Jyoti Seth wrote:
Hello ,
I have two postgres databases on different linux servers. Postgres database
on one server has some tables that needs to be synchronized from the other
postgres database . What should be the best method for this.
The slony replication package lets you choose what tables you replicate.
On the destination server the tables will be read-only.
http://www.slony.info/
Take a little time to read through the documentation and experiment with
a test system first. It works fine, but it's got a lot of complicated
options.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster