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