PostgreSQL streaming replication in PostgreSQL 9.0 and later is excellent if it is suitable, and it is relatively easy to set up, with several walkthroughs on the Internet. The main limitation of the streaming replication is that all the servers which are replicating have to be pretty much identical. They have to be: Same major version […]