PDA

View Full Version : Cant login to pgAdminIII to vaccuum, etc



omaha
04-05-2010, 06:56 AM
Hi, i need to vaccuum, etc, but cant get into pgadmin III

Everytime i try a password, eg postgrespass or dbpass or anything else i may have tried, it gives me the 'an error has occured, cant open file pgpass.conf error 5 access is denied)

Strange thing is i have edited the .conf file from md5 to trust, and i assumed that all of postgres then didnt have any passwords required.

Any ideas?

netsrak
04-05-2010, 07:17 AM
I have never heard of such a file or problem.

The only thing i can suggest is try to start pgadmin as administrator.

I recommend you look for this problem in a postgresql related community like www.postgresql.org

omaha
04-05-2010, 08:29 AM
Getting rid of the password, a la pt3 style

PokerTracker • View topic - How To: Remove PostgreSQL Password (http://www.pokertracker.com/forums/viewtopic.php?f=45&t=4510)


Strange thing is i still cant get in to the pgadminIII and do anything, any other ideas?

Can i get pgadmin to ignore any passwords so i can vacuum the db?

morny
04-05-2010, 12:22 PM
Usually access is denied is a permissions issue, try right clicking on the file, properties, security and click edit and give all the users full permission and try again as it doesn't look like a password issue