Postgresproblem on new autoinstall with Debian 7

Virtualmin
1

Hello,

this exactly describes the problem i have:
The error message is:

Creating PostgreSQL login …
… done
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:

http://stackoverflow.com/questions/11388786/how-does-one-drop-a-template-database-from-postgresql

and then according to this:
http://stackoverflow.com/questions/18870775/how-to-change-the-template-database-collection-coding-on-postgresql

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
Best

2

Experiencing the same thing… did you find a fix?
– Craig

3

I followed the instructions here and it worked perfectly.

http://websymphony.net/blog/2012/10/20/fixing-utf8-encoding-issue-in-postgres/

Here are the instructions too…

postgres=# update pg_database set datallowconn = TRUE where datname = ‘template0’;
UPDATE 1
postgres=# \c template0
You are now connected to database “template0”.
template0=# update pg_database set datistemplate = FALSE where datname = ‘template1’;
UPDATE 1
template0=# drop database template1;
DROP DATABASE
template0=# create database template1 with template = template0 encoding = ‘UTF8’ LC_CTYPE = ‘en_US.utf8’ LC_COLLATE = ‘en_US.utf8’;
CREATE DATABASE
template0=# update pg_database set datistemplate = TRUE where datname = ‘template1’;
UPDATE 1
template0=# \c template1
You are now connected to database “template1”.
template1=# update pg_database set datallowconn = FALSE where datname = ‘template0’;
UPDATE 1

4

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

Will let you know, whether this worked out or not.

Best and thanks again.
j_m

5

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

Best

PS: BTW: Why did i get this problem in the first place? Any1 any idea?

6

How did you fix it?