Cant login to pgAdminIII to vaccuum, etc
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jul 2008
    Posts
    73

    Default Cant login to pgAdminIII to vaccuum, etc

    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?

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,682

    Default

    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

  3. #3
    Member
    Join Date
    Jul 2008
    Posts
    73

    Default

    Getting rid of the password, a la pt3 style

    PokerTracker • View topic - How To: Remove PostgreSQL Password


    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?

  4. #4
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,889

    Default

    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
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

Similar Threads

  1. Login Name to postregsql
    By error_fatsug in forum Manager General
    Replies: 3
    Last Post: 11-07-2009, 11:08 AM
  2. Unable to vaccuum / analyze database
    By malkasgambit in forum Manager General
    Replies: 2
    Last Post: 06-24-2009, 08:02 AM
  3. How do you remove player summary after purge and vaccuum?
    By StrikingEagle in forum Manager General
    Replies: 3
    Last Post: 04-02-2009, 12:32 PM
  4. Do i need to analyse, cluster and vaccuum the db?
    By omaha in forum Manager General
    Replies: 1
    Last Post: 11-28-2008, 01:12 AM
  5. When I manually try to vaccuum analyze through pgadmin
    By probability in forum Manager General
    Replies: 1
    Last Post: 09-15-2008, 11:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •