[2555] - How to change PostGre SQL password?

[rene]

Hello,

i can't remember the postgre sql admin password? How can i reset it?

 

thanks

[Uwe]

the default is "postgres" - did you change it?

[Daria Kotilainen]

Hi Rene, you can check this instruction

 

Daria

[rene]

thanks, i will check it out! I can't remember to have one setup! So it must be the default one

 

[lintujuh]

Here is a link to instructions to reset the postgres password. https://www.postgresqltutorial.com/postgresql-reset-password/

Disclaimer: I haven't tested this myself.

[rene]

On 11/19/2021 at 3:20 PM, Daria Kotilainen said:

Hi Rene, you can check this instruction

 

Daria

this tutorial is not working, the folder structure is not the same and when searching for file "pg_hba.conf" I can't find it

[Daria Kotilainen]

This files is located in the Data folder of PostgreSQL. If you a custom installation was selected when installing PostgreSQL, the file can be in a location different to the one described in the article. Please try to locate PostgreSQL data folder

 

Daria