this exactly describes the problem i have:
The error message is:
Creating PostgreSQL login …
Creating PostgreSQL database xxxxx …
… PostgreSQL database failed! : SQL create database “xxxxx” with owner=“xxxxx” encoding ‘UTF8’ failed : new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) at /usr/share/webmin/web-lib-funcs.pl line 1385, line 1.
Tried to fix it like this:
and then according to this:
But it won’t work, because i cant get the template1 away.
Any help truly appreciated, this $/%$§$%/&() software only uses Postgres, not MySQL…
Thank you very much
Experiencing the same thing… did you find a fix?
I followed the instructions here and it worked perfectly.
Here are the instructions too…
postgres=# update pg_database set datallowconn = TRUE where datname = ‘template0’;
postgres=# \c template0
You are now connected to database “template0”.
template0=# update pg_database set datistemplate = FALSE where datname = ‘template1’;
template0=# drop database template1;
template0=# create database template1 with template = template0 encoding = ‘UTF8’ LC_CTYPE = ‘en_US.utf8’ LC_COLLATE = ‘en_US.utf8’;
template0=# update pg_database set datistemplate = TRUE where datname = ‘template1’;
template0=# \c template1
You are now connected to database “template1”.
template1=# update pg_database set datallowconn = FALSE where datname = ‘template0’;
I’ll give it a try. Had found two other posts here, which had the same problem, without any reply. This is a real showstopper
Will let you know, whether this worked out or not.
Best and thanks again.
Thanks for the help, i was able to fix this problem; now i can activate postges for a virtual host and it creates the according database.
Btw, got a “There are stopped jobs.” message, while trying to log off; i tried it with “exit” but it wouldn’t work so i tried it with “logout”, which didn’t work either so i tried it again with "exi"t. then i was taken back to my root shell.
Beset and thank you very much for pointing this out
PS: BTW: Why did i get this problem in the first place? Any1 any idea?