View Full Version : postgreSQL password
benno74
06-08-2010, 06:30 AM
Hi,
I am trying to vacuum analyze my database but i cant remember my postgreSQL password. Does anybody know how i can find it out or reset it?
morny
06-08-2010, 10:23 PM
Its usually postgrespass by default, if you go to C:/Program Files/RVGSoftware/HoldemManager/Config folder and open the holdemmanager.config file with notepad the 1st couple of lines should also contain your username and password
benno74
06-09-2010, 05:55 AM
Thankyou, I have done that and it shows UID as postgres and PWD as dbpass.
The problem i have now is when i click on the PostgreSQL server 8.3 on the pgAdmin III page it has my user ID as postgresuser and when i put the password in it comes up as FATAL; role "postgresuser" does not exist.
Any advice as to what i need to do now please?
netsrak
06-09-2010, 06:36 AM
You need to change the userid to postgres.
benno74
06-09-2010, 04:10 PM
How do i do that?
morny
06-09-2010, 11:14 PM
Try this FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL))
netsrak
06-10-2010, 02:15 PM
No, thats not what i mean.
You need to double click on the postgresql server in pgadmin and then click on the username on the right side. In my pgadmin version i can change it then.
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.