View Full Version : FATAL 28000: role "postgres" does not exist
RoyalTomek
06-29-2009, 01:48 PM
Hi,
I proceeded as suggested in the Installation Guide but got the following message in Step 8: FATAL 28000: role "postgres" does not exist.
I've already an other poker database program (Pokerstrategy Elephant) that uses PostgreSQL an everything works fine there.
What can I do?
fozzy71
06-29-2009, 02:33 PM
If you are certain you already have postgresql installed, you don't want to install it again. You would want to connect to your existing PostgreSQL server and create a HM DB in addition to your existing PE Database. You will either need the ID and Password for SQL, or you will need to confgure SQL so it doesn't require one.
You must set the postgresql authentication mode for localhost (127.0.0.1) to "trust".
Do this:
Click: "Start -> Programs -> PostgreSQL 8.x -> Configuration files -> Edit pg_hba.conf"
It will open a notepad with some text.
Scroll all the way to the bottom, you should see a line reading this:
#IPv4 local connections:
host all all 127.0.0.1/32 md5
Edit the "md5" to "trust", no quotes. It should now read:
#IPv4 local connections:
host all all 127.0.0.1/32 trust
Save the pg_hba.conf file, and close notepad.
Click: "Start -> Programs -> PostgreSQL 8.x -> Reload configuration"
netsrak
06-29-2009, 02:41 PM
Other possible solutions:
In Elephant you find the database connection infos under Help->Info. You can use the user (elephant?) and the password posted there for the database connection.
or
connect to your database server via pgadmin and create a new role 'postgres' (you find it at the bottom) with the same permissions as the existing elephant role.
RoyalTomek
06-29-2009, 08:22 PM
Thanks for your answers. I took the username and password from PE and it worked.
Christophilius
06-03-2010, 04:51 PM
for beginning, i appologize for my english, very very bad ...
OK, i'm a HM's user since 8 month and it's works good.
I play on Winamax, Pokerstar, Everest and few other minor site and i have never had a problem with that.
Today, when i clicked on "Holdem Manager shortcut" i had this message:
"Holdem manager has found some poker sites on your computer and added the hand history folders to the auto import list and created a backup folder in c:\HMArchive for imported hands. Please check Option - auto import folders to ensute that the list is complet"
I must click on ok.
And the database control panel's window are opening.
When i tried to connect, i can read this message:
Connection Error: FATAL: 28000: "Authentification" by password failed for postgres
http://nsa15.casimages.com/img/2010/06/03/100603104951490151.jpg (http://www.casimages.com)
I dont understand. i have never changed my password
Christophilius
06-03-2010, 05:02 PM
Click: "Start -> Programs -> PostgreSQL 8.x -> Configuration files -> Edit pg_hba.conf"
--> Start --> programs --> postgresql 8.4 : OK
I don't have "configuration files"
I have
--> Documentation
--> Application stack builder
--> PGadminIII
--> Reload configuration
--> Restart Server
--> SQL Shell (psql)
--> Start Server
--> Stop Server
netsrak
06-04-2010, 07:05 AM
Stop the server and use your workplace or explorer to navigate to the postgresql installation folder and look for the pg_hba.conf file, i'm not sure in which subfolder you find it (can't check it at the moment).
Open the file with a texteditor like notepad and change it.
Zielony2009
02-02-2011, 05:53 PM
Excuse me, but I speak little English.
I have a similar problem as in this thread.
When you start holdemmanagera show me the following message: The Following error occurred When trying to open the database: FATAL: database 3D000 'holdemmanager' does not exist
Then there is a second window holdemmanagera, then the horizontal blue box "Connect to PostgreSQL"
Well I type in the box and I received an error such as in the post "Christophilius.
The pg_hba.conf file, all is well. There is no md5 only is trust.
Please help. Ask questions if something was not clear.
Patvs
02-03-2011, 06:16 PM
First to to open dbcontrolpanel.exe--> connect--> and create a new database.
If you can't connect:
This is usually a firewall or windows update issue.
First try to reboot.
If no help, try this:
Start > Programs > PostgreSQL > 8.x > Stop Service
Start > Programs > PostgreSQL > 8.x > Start Service
If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.
If that doesn't help you will have to reinstall PostgreSQL completely
Zielony2009
02-04-2011, 01:29 PM
PostgreSQL has helped to completely uninstall.
Thank you for your help.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.