How to fix Invalid authorization specification in PostgreSQL

# Test connection with explicit credentials
psql -h localhost -U your_username -d your_database -W

# Find pg_hba.conf (typically in the PostgreSQL data directory)
sudo find / -name "pg_hba.conf" 2>/dev/null

# Or ask PostgreSQL directly
sudo -u postgres psql -c "SHOW hba_file;"

# Example pg_hba.conf entry for local socket connections
local   all             all                                     trust

# Example for TCP connections from localhost
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

# Example for TCP from specific IP
host    your_db         your_user       192.168.1.100/32        md5

<type>  <database>  <user>  <address>  <auth-method>

# Using psql as superuser
sudo -u postgres psql -c "SELECT pg_reload_conf();" 

# Or send HUP signal to PostgreSQL process
sudo systemctl reload postgresql
# or
sudo kill -HUP $(pgrep -f "postgres.*master")

sudo systemctl restart postgresql

-- Connect as superuser and check role attributes
\du your_username

-- Output should show "Attributes" like: |
-- Superuser | Create role | Create DB | ...

ALTER ROLE your_username WITH LOGIN;

CREATE ROLE your_username WITH LOGIN PASSWORD 'your_password';

# Using psql
psql -h localhost -U your_username -d your_database -W

# Or using a connection string
psql "postgresql://your_username:your_password@localhost/your_database"

# Check verbose output for debugging
psql -h localhost -U your_username -d your_database -W -v

# View logs (location varies by system)
sudo tail -f /var/log/postgresql/postgresql.log
# or
sudo journalctl -u postgresql -n 50