Posts tagged postgresql
Updrading Postgresql 9.3 to 9.5 with Postgis.
April 29, 2016, 6:21 a.m. postgis , postgresql , pg_dump
encodings for database "postgres" do not match: old "UTF8", new "SQL_ASCII" can be overcome by using /usr/pgsql-9.5/bin/initdb -E 'UTF-8' 9.5 as mentioned in the manual. When you run pg_upgrade, you must provide the following information:   ...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 ...