forget password in the installation of postgresql (second time)

[yrbht]

i have installed postgresql. he gives me password but i forgot it.
Then i remove the program of postgresql and i try to install for the second tine the same program then the step of password he bloqued.
Please tell me what could do for resolving this problem
Thanks sincerely

 

[Leland123]

Hi yrbht,

Install PostgreSQL. As root, make sure all authentication is set to trust in the pg_hba.conf file and restart the postmaster to have the changes in pg_hba.conf take effect. Log into the SQL command line as follows:

psql template1 postgres

Then look at the ALTER USER command per the docs, like here:

http://www.smvfp.com/pgsqlhtml/sql-alteruser.html

For example, the following would set the postgres password to "some_password".

ALTER USER postgres WITH PASSWORD 'some_password';

Once you have the postgres password set, go back and set the pg_hba.conf file to "password"; rather than "trust", restart PostgreSQL or reboot your system to restart PostgreSQL, and see if you can then login.

This is only one way that can be used to authenticate. You might also want to take a look at MD5 authentication.

Regards,

LelandJ



Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox