Hi,
We just noticed something strange with our Postgres server.
We have Postgres 11 and 12 running on macOS 10.14 (Mojave), installed
with the EDB installer. Whenever the machine is restarted, the Postgres
service cannot be launched until a macOS user logs in. We have
"automatic login" turned off in the system preferences, meaning that
when the machine reboots, you get the macOS login screen.
In the system.log we see the following 2 lines over and over again,
until a user has logged in:
Mar 3 09:37:19 postgrestest com.apple.xpc.launchd[1]
(com.edb.launchd.postgresql-12[319]): Service exited with abnormal code:
2
Mar 3 09:37:19 postgrestest com.apple.xpc.launchd[1]
(com.edb.launchd.postgresql-12): Service only ran for 0 seconds. Pushing
respawn out by 10 seconds.
It doesn't matter which macOS user logs in, doesn't have to be an
Administrator. But once a user has logged in, the Postgres service is
finally launched properly. Afterwards, the macOS user can log out again,
and the service will continue running.
It doesn't seem to be limited to Mojave, either. I did a quick test on
our older, decommissioned Postgres server (Postgres 9 on macOS 10.12)
and the same issue seems to occur there.
Has anyone noticed something similar with macOS? Or is it just our
setup?
Best regards,
Nick Renders