Unable to create PostgreSQL database

[aliciaquays]

Hi, I'm running in to the following issues when I try to create a database for PT4. I've run PostgreSQL before for Hold'em Manager and have two databases for that already.

"Unable to create PostgreSQL database: PT4 DB
Reason: Unable to execute query: --

-- Table: cash_hand_summary
--

Create Table cash_hand_summary (

...alot of text"

I've got all things set as standard (apart from the password which I changed some time ago) ie.
Server: localhost User: postgers
Port: 5432 Password: password

I've also made sure my firewall allows the ports (since running with HEM)

When I try to create a database with my firewall turned off, I get another message:
"Unable to create PostgreSQL database: PT4 DB
Reason: Unable to execute quert: Create Database "PT DB" WITH TEMPLATE = template0
ENCODING = 'UTF8';;Reason: Fatal Error (ERROR: database PT4 DB" already exists )"

Although when I check the "This database already exists" box, it sais it's not a "valid database"

Thank you in advance.

[WhiteRider]

Please try creating a new database with a different name (both the "Name" that PokerTracker uses and the "Database" in the PostgreSQL Server Information) and see if that works OK?

[aliciaquays]

I tried changing the name on both of the lines. I do however still get the error message presented first in my original post:

[kraada]

Unfortunately that screenshot does not show the entire error. Could you copy it and paste it into a support ticket for us? The entire error will be more useful than the picture portion.

[aliciaquays]

I managed to get this sorted by reinstalling PostgreSQL 8.3

Thanks for the help guys.