Posts tagged pg_dump

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