I downloaded pgadmin4 on my mac a couple weeks ago to practice sql for a job change. It worked alright until yesterday. I kept receiving this prompt to connect to the server:
Unable to connect to server: connection failed: :1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at “localhost” (127.0.0.1), port 5432 failed: Connection refused Is the server running on that host and accepting
TCP/IP connections?
I have absolutely no idea how to manually start the server. I tried googling, but I couldn’t find anything that works.. Then I found an app in the library called Reload Configuration. I clicked this and somehow the server started running.
But this morning, when server isn’t connected again, and I tried clicking the Reload Configuration app once more, this message comes up:
pg_ctl: PID file “/Library/ PostgreSQL/16/data/
postmaster.pid” does not exist
Is server running?
pg_ctl: PID file “/Library/PostgreSQL/16/ data/postmaster.pid” does not exist
Is server running? (1)
Can anyone please help me point out how exactly do I manually connect to the postgres server on my mac? It’s getting so frustrating now.
amyham is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.