PDA

View Full Version : Database creation error



Folding
08-27-2008, 04:16 PM
Hi, I am sorry if this is the wrong place to post this.

I downloaded Holdem Manager, installed it, connected to PostgreSQL and clicked on the "Create New Database" button.

I get the following error:

"The following error occurred when trying to initialize the Holdem Manager database: ERROR: XX000: encoding SQL_ASCII does not match server's locale en_US.UTF-8"

The PostgreSQL (8.3.1) server is on a remote Linux box. I do not have a problem using it from PokerTracker. I can access it fine, including creating databases using psql.

Any ideas on how to fix or work around this?

I have read the FAQ.

Thanks

Folding
08-27-2008, 05:45 PM
The database had to be created by a superuser. Then it works.

I would rather not connect as a superuser, so what I am going to do is drop the current Holdem Manager database, change my user to be a superuser, create the database, and remove my superuser permission.

Do I need to be a PostgreSQL superuser to run Holdem Manager?

Rvg72
08-27-2008, 08:07 PM
The database had to be created by a superuser. Then it works.

I would rather not connect as a superuser, so what I am going to do is drop the current Holdem Manager database, change my user to be a superuser, create the database, and remove my superuser permission.

Do I need to be a PostgreSQL superuser to run Holdem Manager?

You shouldn't need a superuser to run HM but the user does need the ability to drop / create tables

Roy