Postgresql connection to server on socket "/tmp/.s.PGSQL.5432" failed on MacBook - psql

This issue occurs when your postgresql server is not running or postgresql cannot connect to the database using the socket.

Follow the below steps to resolve this issue:

1. Remove the postmaster.pid. rm /usr/local/var/<postgresql-version>/postmaster.pid

example: rm /usr/local/var/postgres@15/postmaster.pid

1. Restart the postgresql. brew services restart postgresql