How to Change the PostgreSQL Administrator Password

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

There may be a time when you forget your PostgreSQL administrator password. The process below describes how you can log in without a password to change the password of PostgreSQL.

How to Log In to PostgreSQL Without a Password

  1. Search for pg_hba.conf which should be located in C:\Program Files\PostgreSQL\9.3\data
  2. Right click and edit pg_hba.conf using a text editor 

  3. Scroll down the text file and you will see something as described in the screenshot below :
  4. Change the "md5" method to "trust" and save the file as described in the screenshot below:
  5. Login to PostgreSQL using pgAdmin, without a password
  6. From there on you should be able to go to the UI and change the password
  7. Edit pg_hba.conf using a text editor and change "trust" back to "md5"
  8. Password is now changed!

 

最終更新日: 2015 年 10 月 7 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.