[MacPorts] #68348: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed

[MacPorts]

#68348: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed
----------------------------------+--------------------
  Reporter:  conradwt             |      Owner:  (none)
      Type:  defect               |     Status:  new
  Priority:  Normal               |  Milestone:
 Component:  ports                |    Version:
Resolution:                       |   Keywords:
      Port:  postgresql15-server  |
----------------------------------+--------------------

Comment (by conradwt):

 The following issue [#68412](https://trac.macports.org/ticket/68412)
 appears to be the root cause that I'm seeing in both postgresql15-server
 and postgresql16-server.  For example, when you run the following:

 {{{
 ➜ dscl . -read /Users/postgres UserShell
 UserShell: /usr/bin/false
 }}}

 This appears to be a new security measure introduced by Apple in macOS
 14.0.0 (Sonoma), macOS 11.7.10 (Big Sur), and possibly other macOS
 versions.

 Option #1

 I recommend updating the notes for all effective postgresqlXY-server ports
 to include the following:

 macOS Catalina and newer

 {{{
 sudo chsh -s /bin/zsh postgres
 }}}

 Otherwise

 {{{
 sudo chsh -s /bin/bash postgres
 }}}

 Option #2

 Add a user account and group to User & Groups within System Preferences or
 System Settings.  I believe that this may be the better option of the two
 because it's easier for an end user to manage any created user accounts.

-- 
Ticket URL: <https://trac.macports.org/ticket/68348#comment:5>
MacPorts <https://www.macports.org/>
Ports system for macOS