Posts tagged replication

Postgresql streaming replication

May 8, 2015, 5:48 a.m. postgresql , streaming , replication , repmgr , roadlk

On Monday was offline for nearly an hour. It was due to the primary database server crashing, no data was lost but the automatic failover hadn't kicked into action automatically. For nearly two years operated with just log shipping WAL archives. We took a pg_basebackup about once ...