Postgresproblem on new autoinstall with Debian 7

6 posts / 0 new

Topic locked

#1 Wed, 09/03/2014 - 07:01

just_me

Postgresproblem on new autoinstall with Debian 7

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...

and then according to this: http://stackoverflow.com/questions/18870775/how-to-change-the-template-d...

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 Fri, 09/05/2014 - 13:13

isdahlc

Experiencing the same thing... did you find a fix?
-- Craig

#3 Fri, 09/05/2014 - 14:28

isdahlc

I followed the instructions here and it worked perfectly.

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

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 Mon, 09/08/2014 - 01:27

just_me

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. j_m

#5 Mon, 09/08/2014 - 01:47

just_me

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

Best

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

#6 Sat, 11/22/2014 - 05:53

fuerst

How did you fix it?

Topic locked