PDA

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.