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

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

Moderator: Moderators

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

Postby APerfect10 » Fri Feb 01, 2008 7:59 pm

So you installed PostgreSQL by itself prior to PokerTracker 3? I think it will be more hassle to uninstall/reinstall as that leads to issue IMHO.

Lets try removing the need for a password then using the "postgres" username.

Go Start->Program Files->PostgreSQL 8.2->Configuration Files->Edit pg_hba.conf

Scroll to the bottom of the conf file and change the two lines that contain "md5" to "trust".

File->Save. Restart PostgreSQL (or your computer). Then when you are prompted to enter a username, use "postgres" and omit the password field.

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm

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

Postby Chaser8 » Fri Feb 01, 2008 10:08 pm

Wow I think my postgres installation is cursed. I got this msg:

... FATAL ROLE "postgres" does not exist
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

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

Postby _dave_ » Fri Feb 01, 2008 10:19 pm

[quote="Chaser8"6qy]Wow I think my postgres installation is cursed. I got this msg:

... FATAL ROLE "postgres" does not exist[/quote6qy]

it won't if I understood your earlier posts correctly - I thought you installed postgres but changed the superuser name to "Chaser" - or was that some other account?
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

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

Postby APerfect10 » Fri Feb 01, 2008 10:25 pm

[quote="_dave_"n3i][quote="Chaser8"n3i]Wow I think my postgres installation is cursed. I got this msg:

... FATAL ROLE "postgres" does not exist[/quoten3i]

it won't if I understood your earlier posts correctly - I thought you installed postgres but changed the superuser name to "Chaser" - or was that some other account?[/quoten3i]

That is what we are trying to figure out. It's saying no role is defined for "Chaser" and now "postgres". He must have used some other name, in which case we will have to query PostgreSQL to figure out.
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm

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

Postby APerfect10 » Fri Feb 01, 2008 10:29 pm

Launch pgAdmin3 which is located in your PostgreSQL\8.2\bin directory. Double click your database server to connet and expand the "Login Roles". What usernames are listed here?

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm

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

Postby _dave_ » Fri Feb 01, 2008 10:31 pm

He did at the end of the last page... that's what I was referring to:

[quote="Chaser8"3mn]Here's a shot of my pgAdminIII

http://img201.imageshack.us/my.php?imag ... hotns5.jpg[/quote3mn]
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

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

Postby _dave_ » Fri Feb 01, 2008 10:33 pm

Wait one sec... you're not using a windows account also named "Chaser" are you?
_dave_
 
Posts: 1147
Joined: Sun Dec 09, 2007 6:19 pm

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

Postby Chaser8 » Fri Feb 01, 2008 10:37 pm

my windows xp login? No. I have two accounts in winxp. One is my first name, the other is "work." Both of which have admin.
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

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

Postby APerfect10 » Sat Feb 02, 2008 2:23 am

[quote="_dave_"8pu]He did at the end of the last page... that's what I was referring to:

[quote="Chaser8"8pu]Here's a shot of my pgAdminIII

http://img201.imageshack.us/my.php?imag ... hotns5.jpg[/quote8pu][/quote8pu]

Oops, either I completely overlooked that or saw it previously and forgot (since dealing with so many other topics). Well then that makes no sense to me. That picture clearly shows that role "Chaser".

I assume your pgAdmin3 window still looks identical to that? Listing the role "Chaser"? You did not accidentally do something to that table via pgAdmin did you?

Could you please select "Chaser" under Login Roles so that I can see your account settings in the "Properties" tab?

Best regards,

Derek
APerfect10
Site Admin
 
Posts: 4464
Joined: Sat Dec 08, 2007 6:03 pm


PreviousNext

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 47 guests

cron
highfalutin