x Bucharest - Connecting to Postgres

Type: Fix
Description: A web application relies on the PostgreSQL 13 database present on this server. However, the connection to the database is not working. Your task is to identify and resolve the issue causing this connection failure. The application connects to a database named app1 with the user app1user and the password app1user.

Credit PykPyky

Test: Running PGPASSWORD=app1user psql -h 127.0.0.1 -d app1 -U app1user -c '\q' succeeds (does not return an error).

Notes and solution:

The solution is to check the configuration file pg_hba.conf for the SQL server located in /etc/postgresql/$version/main/, there you have to delete or comment all the configuration lines with the word reject.