PostgreSQL replication and large import I am tasked with making large PostgreSQL imports to master instance, and then replicate it across the nodes as read-only data.

Still, the CMS system has to be able to write data and replicate across all of them.

I can use the latest version of PostgreSQL server. There are just few tables in single database.

I havent been working with PostgreSQL for 5 years, so I was wondering if this is doable the same way as with MySQL, that I have the DM and so on?

The thing is, that I need to run it in two data centres, so ideally it would be close to:


2 master PostgreSQL instances, which are doing writes from CMS and imports
10 slave PostgreSQL instances doing only reads.


Is there any preferred approach in doing this for PostgreSQL?
This sounds like an ideal candidate for streaming replication with hot standby.

Alternatives are listed on the Replication wiki page.