Any ideas?

Iv got postgres installed on a windows server 2003 box, but I get the error

Unable to create PostgreSQL database: PT3 DB
Reason: Unable to execute query: CREATE DATABASE "PT3 DB" WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII';; Reason: Fatal Error (ERROR: encoding SQL_ASCII does not match server's locale English_United States.1252 DETAIL: The server's LC_CTYPE setting requires encoding WIN1252. )

Im not a strong DBA :S any clues? Do i need to change the locales on the server? If so - what to?

Does the database really need SQL_ASCII ? Cant I create the DB, and link it it manually or would it not create the tables that way?

Do you mean PT3? There isn't yet a PTO3..
When/where do you get that message? What are you trying to do?

Sorry yes PT3 sorry

I been using PTO stupid habbit - just trying NLHE

When I try and setup a database after first install, loading the DB on to the same server where my PTO DB is.

You do need to install PostgreSQL with WIN1252 encoding. This should be a setup option when installing PostgreSQL on the same page where you initialize the database cluster. Once you have this setting set properly, everything should function properly as well.

I have already installed it - how can I change this locale after install?

I installed it using the package from postgre's website.

I believe the only way to do this is to uninstall and reinstall PostgreSQL. For more on how to uninstall and reinstall properly please see this FAQ.

done thanks. reinstall++ PTO seems to be fine with that encoding now too

It was the one-click setup from postgre i think that caused the grief - didnt give me any options obv.

I'm not sure why our streamlined install wouldn't install it correctly for you, but I'm glad to hear it's working well now.

i didnt use the streamlined version - sorry postgre also offers a 1-click-install system

i used this as on the box i didnt have PT3 (so not the included install thingy). might be worth making the msi+config package avail sep from PT so ppl can install postgre on another box, 1 click style, with the right encoding or whatnot.

The version of PT3 that comes with PostgreSQL on our download page comes with the PostgreSQL installer in a simpler setup so as to avoid complications, and it really should select the right encoding for you.

I guess fail at what happened

I have 1 computer for server, 1 computer for poker, obviously the server didnt make sense for me to install full PT3 on, but as it's super powerful made sense for me to use as DB over my desktop or cheap laptop

I was just suggesting make a package with just the db setup

hope that makes sense, eitherway downloaded and did full postgre-reinstall with the right params and is OK now.

close thread already! thanks.