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