RDBMS - PostgreSQL - Fatal Error - Error connecting to the server FATAL password authentication failed for user operator

This page provides solution for the below error which is encountered while connecting to PG Admin

Error: An error has occurred:

Error connecting to the server: FATAL: password authentication failed for user "operator"

1. Open PGAdmin
2. Try to add a connection to the server
3. Fill all the fields and click OK

This issue may occur in the following two scenarios :

1. Username and password entered in the connection profile is wrong
   Solution - Cross check and make sure to enter the right user name and password. For example for user "Operator" the password is "CastAIP"
   
   
2. The Account is expired for the user being used in the connection profile.
   Solution - To check if the Account is expired for the user being used in the connection profile, connect to server with "admin" user (password CASTSA) and expand the login Roles and see the properties of the user as shown below:
   
   1. Click on the definition tab and notice the "Account expires" option. If this check box is checked and the date is already expired, then the solution is to either enter valid date or simply uncheck this option.
      

Ticket # 1715