PostgreSQL

Localhost 5432 Issues?

Port 5432 is the standard for Postgres. Common errors include connection refused or password authentication failed.

Troubleshoot Postgres
Kill Port 5432
npx kill-port 5432

Postgres Connection Fixes

If you see Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections?, check these.

1. Start Postgres Service

Postgres doesn't start automatically on some installs.

MacOS (Homebrew): 
brew services start postgresql

2. Check the Log File

Often the lock file postmaster.pid prevents startup after a crash. Deleting it (carefully) can fix the issue.

rm /usr/local/var/postgres/postmaster.pid

Developer Port Reference Guide

Frontend & Web
3000 React / Node / Default 3001 React Secondary
Backend & Infrastructure
5000 Flask / AirPlay 4000 Jekyll / Hexo
Database & Cache
3306 MySQL 5432 PostgreSQL
DevOps & Data Science
8888 Jupyter Notebook 9200 Elasticsearch 9090 Prometheus 15672 RabbitMQ UI 8500 Consul 127.0.0.1 Loopback IP