Results 1 to 5 of 5

Thread: Just Forgot

  1. #1
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Unanswered: Just Forgot

    All,

    Do not use PG that often and have it installed on several PCs. Have it turned off normally so have to go to:

    Start + All Programs + System Tools + Administrative Tools + Services

    find PG in the list and start. Then I open my pgAdminIII and attempt login.

    Somehow it is not accepting the UID/PWD combo I set for this, and I have forgotten the defaults, so can not get in. I have been looking for the install notes to find the defaults but forgot where I put them and could not find online.

    A quick help with HOWTO URL would be nice right now!

    Thanks!

    DBS4M

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Edit pg_hba.conf (in your data folder), find the line for localhost and set the method to "trust." Restart the server and login to your windows postgres user account. You'll be able to connect w/o a password and run:
    Code:
    alter user postgres with password 'xxx'
    I'm much more familiar w/ postgres on Linux, but hopefully that'll work on Windows.

  3. #3
    Join Date
    Feb 2004
    Location
    Irving, TX (Dallas, Fort Worth)
    Posts
    379

    Example

    A,

    Attached my pg_hba file. Had to use copy with .txt extension as upload here does not accept .conf.

    Active lines are:
    Code:
    # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
    
    # IPv4 local connections:
    host    all         all         127.0.0.1/32          md5
    # IPv6 local connections:
    #host    all         all         ::1/128               md5
    I assume you are saying change the "md5" to "trust"?

    Since port is actually 5432 was thinking host line should read":

    host all all 127.0.0.1/5432 md5

    Am I right?

    DBS4M
    Attached Files Attached Files

  4. #4
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Code:
    host    all         all         127.0.0.1/32          md5
    needs to be:
    Code:
    host    all         all         127.0.0.1/32         trust
    The "/32" indicates the subnet mask. (255.255.255.0 = 24, 255.255.0.0 = 16, 255.0.0.0 = 8)

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    and, make SURE you change it back after you reset the PW...
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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