On Tue, 2020-11-03 at 09:42 -0600, Doug Whitfield wrote:
> Unclear to me if this is a systemd bug or a Postgresql 12 bug, so I figured I would get some thoughts here before
reportingin detail.
>
> It is pretty simple to reproduce. If you start your standby server with incorrect username or password
> using ’systemctl start postgresql-12’ then systemctl just “hangs”. The replication issues get logged,
> and it isn’t hard to fix, but it doesn’t seem like the appropriate outcome. If you make a syntax error,
> the systemctl knows that you failed. Of course, this is better than having a normal exit status and
> moving on with life only to find out your replication isn’t working, but it doesn’t seem right.
>
> To be clear, I already fixed the issue. I am just wondering if people think this is a systemd bug
> or a PostgresQL bug or it is just a garbage in, garbage out sort of situation not worth filing anywhere.
That must be the "Type=notify" from the service file.
PostgreSQL notifies systemd as soon as it has started up, which didn't happen in your case.
The idea is that later services that depend on PostgreSQL can rely on it being available.
I think that is a good thing to have.
I am no systemd expert, but as far as I know services are started in parallel, so it
shouldn't block your boot process for other services that don't depend on PostgreSQL.
The best place to discuss this would be the "pgsql-pkg-yum" list.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com