[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):

 During testing, I have noticed that `sudo port load postgresql15-server`
 will create the following processes:

 {{{
 postgres          5625   0.0  0.0 408204320   6128   ??  S     1:50PM
 0:00.03 /usr/sbin/cfprefsd agent
 postgres          1140   0.0  0.0 408303616  11968   ??  S    10:47AM
 0:03.65 /usr/libexec/trustd --agent
 postgres          1123   0.0  0.0 408283664  10496   ??  S    10:46AM
 0:00.33 /usr/libexec/containermanagerd --runmode=agent --user-container-
 mode=current --bundle-container-mode=proxy --system-container-mode=none
 postgres          1122   0.0  0.0 408462496  21248   ??  S    10:46AM
 0:00.26 /usr/libexec/secd
 postgres          1121   0.0  0.0 408073248   3568   ??  S    10:46AM
 0:00.01
 /System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCore.framework/Versions/A/XPCServices/csnameddatad.xpc/Contents/MacOS/csnameddatad
 postgres          1120   0.0  0.0 408303136  16816   ??  S    10:46AM
 0:00.08 /usr/libexec/lsd
 postgres          1119   0.0  0.0 408302048  14512   ??  S    10:46AM
 0:00.06 /usr/libexec/pkd
 postgres          1116   0.0  0.0 408249984  30720   ??  SN   10:46AM
 0:22.38
 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdbulkimport
 -s mdworker-bundle -c MDSImporterBundleFinder -m
 com.apple.metadata.mdbulkimport
 postgres          1107   0.0  0.0 408185888   5616   ??  S    10:46AM
 0:01.32 /usr/sbin/distnoted agent
 }}}


 Also, when I list the contents `/opt/local/var/db/postgresql15`, I'm
 seeing the following:

 {{{

 ➜ ls -al /opt/local/var/db/postgresql15
 total 0
 drwxr-xr-x@  4 postgres  postgres  128 Jun  4 03:39 .
 drwxr-xr-x@  6 postgres  postgres  192 Oct  5 16:48 ..
 drwx------  11 postgres  postgres  352 Jun  4 03:41 Library
 drwx------  25 postgres  postgres  800 Oct  3 23:11 defaultdb

 ➜ sudo ls -al /opt/local/var/db/postgresql15/Library
 Password:
 total 0
 drwx------  11 postgres  postgres  352 Jun  4 03:41 .
 drwxr-xr-x@  4 postgres  postgres  128 Jun  4 03:39 ..
 drwx------   6 postgres  postgres  192 Sep 27 06:16 Application Scripts
 drwx------   2 postgres  postgres   64 Jun  4 03:39 Audio
 drwx------   3 postgres  postgres   96 Jun  4 03:39 Caches
 drwx------   3 postgres  postgres   96 Oct  1 18:28 ContainerManager
 drwx------   6 postgres  postgres  192 Sep 27 06:16 Containers
 drwx------   3 postgres  postgres   96 Jun  4 03:39 Keychains
 drwx------   2 postgres  postgres   64 Jun  4 03:39 Mail
 drwxr-xr-x   4 postgres  postgres  128 Oct  1 18:28 Preferences
 drwx------   2 postgres  postgres   64 Sep 27 06:16 Staging

 ➜ sudo ls -al /opt/local/var/db/postgresql15/Library/Preferences
 total 40
 drwxr-xr-x   4 postgres  postgres    128 Oct  1 18:28 .
 drwx------  11 postgres  postgres    352 Jun  4 03:41 ..
 drwxr-xr-x   3 postgres  postgres     96 Jun 22 11:49
 com.apple.LaunchServices
 -rw-r--r--   1 postgres  postgres  20480 Jun  4 03:41
 com.apple.LaunchServices.QuarantineEventsV2
 }}}


 This looks like to macOS Sonoma issue but I'm not sure what's going on
 here.

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