Unable to create PostgreSQL database: PT3 Alpha....

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Unable to create PostgreSQL database: PT3 Alpha....

Postby Chaser8 » Thu Jan 24, 2008 8:08 pm

I got this message when I tried to create my new pt3 db for the first time:

Unable to create PostgreSQL database: PT3 Alpha DB1
Reason: Unable to execute query: CREATE DATABASE "PT3 Alpha DB1" WITH OWNER = Chaser ENCODING = 'SQL_ASCII' TABLESPACE = pg_default;; Reason: Fatal Error (ERROR: role "chaser" does not exist )

I double-checked my postgre login details and my login and password is correct. How to fix?
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby _dave_ » Thu Jan 24, 2008 8:21 pm

Login name should probably be "postgres" (with associated password). PGSQL seems to think user "Chaser" does not exist.
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby Chaser8 » Thu Jan 24, 2008 8:27 pm

[quote="_dave_"]Login name should probably be "postgres"[/quote]

No, it shouldn't because I set my login name as "Chaser," and not "postgre." If I use anything else, it says user authentication failed.

I run spade eye perfectly fine with my postgre db login and password.
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby Josh » Thu Jan 24, 2008 8:34 pm

Try using "postgres" with an empty password.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby Chaser8 » Thu Jan 24, 2008 8:41 pm

[quote="Josh"]Try using "postgres" with an empty password.[/quote]

I got this message

Unable to create PostgreSQL database: PT3 Alpha DB1
Reason: Unable to login to database (template1). Reason: fe_sendauth: no password supplied
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby Josh » Thu Jan 24, 2008 8:43 pm

OKay, that's not going to work. Can you post or attach a screenshot to a support ticket of the settings for the "Chaser" login?
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby holepunch » Thu Jan 24, 2008 10:13 pm

if anyone is installing post gres on a vista machine, it has to be done with the user account setting switched off in the control panel,you can switch it back on again after installation, also pt3 has to be run as administrator
holepunch
 
Posts: 11
Joined: Thu Jan 24, 2008 7:53 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby holepunch » Thu Jan 24, 2008 10:14 pm

sry that should be user account control
holepunch
 
Posts: 11
Joined: Thu Jan 24, 2008 7:53 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby Chaser8 » Fri Jan 25, 2008 3:49 am

Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Unable to create PostgreSQL database: PT3 Alpha....

Postby _dave_ » Fri Jan 25, 2008 3:53 am

[quote="Chaser8"xe5]http://img204.imageshack.us/my.php?image=postgresqo6.png

This?[/quotexe5]
That looks like HM...

Unless you are certain what you are doing, changing the superuser name to not "postgres" is a recepie for disaster imo.
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

Next

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 24 guests

cron
highfalutin