Jump to content

does port need to be opened for postgres

Recommended Posts

does port need to be opened for postgres, standard port 5432 in the firewall rules?

I get the following error consistently for macOS Ventura and Sonoma:

 psql fred --username dwilbur --host
psql: error: connection to server at "", port 5432 failed: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.

note that this happens before it even gets to the point of asking for a password.

this happens for either postgres from homebrew, or Postgres.app.

this didn't seem to be an issue in the past... so am not sure why its happening now.

I would be useful to have instructions on what specifically I would need to do for the firewall to allow both way communication to remote connections for the postgres server.  

note, postgres configuration is correctly setup and working for socket based connections.

Link to comment
Share on other sites

  • Administrators

If temporarily disabling the firewall make a difference, try activating learning mode until the necessary rules are created.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...