To list all files in current directory including dot files (hidden files or directories), as well as print permissions :
ls -laOpenNMS Postgresql ASCII error fix
-
Recreate postrgresql database template encode to ASCII
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
Now we can drop it:
DROP DATABASE template1;
Create database from template0, with a new default encoding:
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
\c template1
VACUUM FREEZE;