Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2014
    Posts
    17

    Unanswered: Forgotten PostGre USer password

    i have forget the password for Postgre USer not i couldnt able to login.
    How can i reset it ? See the attached screen.
    Attached Thumbnails Attached Thumbnails error.png  

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    It's Postgres not PostGre

    A quick internet search using the terms "postgres forgot password" returns the following matches:

    http://www.dbforums.com/postgresql/1644958-password-authentication-failed-user-postgres.html
    http://wiki.spry.com/Change_forgotten_PostgreSQL_password
    http://www.tekovic.com/changing-forgotten-postgresql-password
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Mar 2014
    Posts
    17
    how can i start the Psql ? Please tell me steps. i have installed the pgadmin

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by BhuvneshDogra View Post
    how can i start the Psql?
    You start it the same way as any other command line program: by typing its name. (In this case: type psql in the command line)
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  5. #5
    Join Date
    Mar 2014
    Posts
    17
    HI shamat ,

    today i re-installed everything . (pgAdmin, Pgbouncer , Postgresql etc..) but agaain installtion got stuck when we set the credential like window where we set

    localhost
    maintenancedb
    UserName
    Password.


    for POstgres User , whatever password i am setting , it showing FATAL error with authentication failed error.

    PLease Help.

Posting Permissions

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