Posts tagged streaming

Postgresql streaming replication

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

On Monday road.lk 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 road.lk operated with just log shipping WAL archives. We took a pg_basebackup about once ...