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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

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