PDA

View Full Version : PGAdmin Password Error - Vacuum



ScottieB_08
01-17-2010, 09:39 AM
Hi, I am having problems entering PGAdmin III; it is saying my password (postgrespass) is incorrect.

Can you tell me the way I can turn off passwords in PGAdmin III? I saw a thread on it a month back and it worked. However, I have had to reinstall SQL 8.3 and now it doesn't work again.

Many thanks.

fozzy71
01-17-2010, 12:33 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://www.holde
mmanager.net/faq/afmviewfaq.aspx?faqid=66