If you're experiencing an issue logging into UAM, it may be a credential issue. To resolve this, follow these steps:
Check pg_hba.conf: This file contains the authentication rules for PostgreSQL.
To open the file, run:
sudo nano /etc/postgresql/11/main/pg_hba.conf
Then check if the following line exists:
# TYPE DATABASE USER ADDRESS METHOD host all all 127.0.0.1/32 md5
If the line does not exist, add it.
Save and Exit by pressing ‘Ctrl + s’ followed by ‘Ctrl + x’.
Restart the PostgreSQL server by running these two commands:
sudo systemctl stop postgresql sudo systemctl start postgresql
Check postgresql.conf: This file contains configuration options for PostgreSQL.
To open the file, run:
sudo nano /etc/postgresql/11/main/postgresql.conf
Change the listening addresses: Look for the line that says listening_addresses and change it to:
listen_addresses = 'localhost,127.0.0.1'
If the line is commented out, denoted by a ‘#', delete the '#’.
Save and Exit by pressing ‘Ctrl + s’ followed by ‘Ctrl + x’.
Restart the PostgreSQL server by running these two commands:
sudo systemctl stop postgresql sudo systemctl start postgresql