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: &nbsp ...

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 ...