Ubuntu 22.04 LTS – PostgreSQL refuses remote connections – Fix & Prevention

📖 ~1 min read

Table of contents

1. Symptom & Impact
2. Environment & Reproduction
3. Root Cause Analysis
4. Quick Triage
5. Step-by-Step Diagnosis
6. Solution – Primary Fix
7. Solution – Alternative Approaches
8. Verification & Acceptance Criteria
9. Rollback Plan
10. Prevention & Hardening
11. Related Errors & Cross-Refs
12. References & Further Reading

Symptom & Impact

Remote clients cannot connect to PostgreSQL on Ubuntu 22.04.

Environment & Reproduction

Typical after fresh install with default localhost binding.

Root Cause Analysis

listen_addresses and pg_hba.conf rules do not permit remote traffic.

Quick Triage

Check active bind address and authentication rules.

Step-by-Step Diagnosis

Validate postgres config path and parse errors before reload.

Solution – Primary Fix

Allow required subnets in pg_hba and set listen_addresses.

Solution – Alternative Approaches

Use SSH tunneling for limited secure remote access.

Verification & Acceptance Criteria

Authorized remote clients connect and authenticate successfully.

Rollback Plan

Restore previous postgres configs and restart service.

Prevention & Hardening

Use least-privilege CIDR rules and SSL for remote DB access.

Related Errors & Cross-Refs

Related to UFW denies and DNS host-based auth mismatches.

Related tutorial: View the step-by-step tutorial for Ubuntu 22.04 LTS.

View all Ubuntu 22.04 LTS tutorials on the Tutorials Hub →

Browse all common problems & solutions on the Tutorials Hub.

References & Further Reading

Ubuntu PostgreSQL networking and authentication docs.