TROUBLESHOOTING AREA
PostgreSQL
Roles, authentication, and connection errors. Start with the exact error or symptom below.
PostgreSQLPostgreSQL “Connection refused”: start the server, then read its logPostgreSQLPostgreSQL “database does not exist”: list, create, connect with -dPostgreSQLPostgreSQL “password authentication failed”: reset the password, check pg_hbaPostgreSQLPostgreSQL “Peer authentication failed”: match the OS user or use passwordsPostgreSQLPostgreSQL “role does not exist”: create the role or pass -U