Replicate selected postgresql tables between two servers?

Question

What would be the best way to replicate individual database tables from the master postgresql server to a slave computer? This can be done using cron + rsync, or with any post-Congress that can be built-in, or some OSS tool, but so far the postgres docs don't seem to cover table replication methods. I cannot perform full database replication, because in some tables the license-> IP file is connected to it, and I cannot replicate them on a slave machine. I don't need instant replication, and hourly would be acceptable.

If I just need rsync, can someone help determine which files in the / var / lib / pgsql directory will need to be synchronized or how I will know which tables they are.

Answer 1

You cannot get anything useful by copying individual table files to the data directory. If you want to replicate selected tables, there are a number of good options.

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

Answer 2

You might want to try Bucardo, which is open source software to synchronize rows between tables, even if they are in a remote place. This is a very simple software, and it is also capable of creating one-way synchronization relationships.

Check out http://bucardo.org/wiki/Bucardo