Scenario: "Bucharest": Connecting to Postgres

Level: Easy

Type: Fix

Tags: postgres  

Access: Email

Description: A web application relies on the PostgreSQL database on this server. After a client-authentication change, that connection fails.

The application connects over TCP to 127.0.0.1, database app1, user app1user, password app1user. The role and password are already set. Do not replace the database or the account; restore this connection. It must still work after a reboot.

Root (sudo) Access: True

Test: This command succeeds (exits 0, no error):
PGPASSWORD=app1user psql -h 127.0.0.1 -d app1 -U app1user -c '\q'

The "Check My Solution" button runs the script /home/admin/agent/check.sh, which you can see and execute.

Time to Solve: 15 minutes.