Linux - Mandriva - Webdesign - Windows - Netzwerk
ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
Antwort
su - postgres
psql
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
Kommentar schreiben