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

Reply via email to