Re: Database Synchronization

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