Password error for the PostgreSQL user.

Question

I am getting a problem at the installation process of this software like clsRCDCInfo:CreateRCDCDatabase - FATAL: 28000: password authentication failed for user "PostgreSQL". What it means? How can I solve this?

Answer 1

The error means you have used a wrong password for the PostgreSQL database. To overcome this error, start the PostgreSQL configuration utility and change or memorize the password for the postgresql user then repeat the attempt and it should install fine. To change the password, open a psql session and type the following command:

ALTER USER Postgres WITH PASSWORD '<newpassword>';