Unable to create PostgreSQL database
Posted: Wed Feb 01, 2012 7:36 pm
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.
"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.