Bash script – clone PostgreSQL replica

This script helps you create new PostgreSQL replica by cloning existing one. You have to prepare your new machine/ instance with as much the same environment as possible to your previous one. You definitely need the same main version of PostgreSQL and preferably also...

Streaming replication – installation notes

To create new replica from master is in PostgreSQL much easier then in MySQL. In MySQl you have to flush tables on master with read lock and make backup. Which means during backup users cannot insert/update data. In PostgreSQL you can use pg_basebackup tool. It runs...