2,306
edits
Changes
Jump to navigation
Jump to search
Line 59:
Line 59: + + + + + + + + + + + + + +
no edit summary
== Import .sql dump file ==
== Import .sql dump file ==
psql databasename < data_base_dump
psql databasename < data_base_dump
== Error creating UTF-8 database ==
02:39:35: Error: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
SUGERENCIA: Use the same encoding as in the template database, or use template0 as template.
Fix:
<nowiki>update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';</nowiki>