Re: PostgreSQL 15 on Fedora 37 Does not start after reboot

Fedora Bugzila report ID 2157651 has been submitted.

Thanks

Tom

p { line-height: 115%; margin-bottom: 0.1in; background: transparent }a:link { color: #000080; so-language: zxx; text-decoration: underline }

Tom Dryden <tdryden@comcast.net> writes:

PostgreSQL 15 on Fedora 37 Does not start after reboot
The service is enabled and reports a network error after reboot. 
Starting the postgresql service manually after the reboot is successful.

 From the log file:

2023-01-01 09:22:26.406 EST [812] LOG: starting PostgreSQL 15.1 on 
x86_64-pc-linux-gnu, compiled by gcc (GCC) 12.2.1 20220819 (Red Hat 
12.2.1-2), 64-bit
2023-01-01 09:22:26.406 EST [812] LOG: could not bind IPv4 address 
"192.168.122.124": Cannot assign requested address

This indicates that Postgres is starting before the network
interface is up, something that systemd is prone to try to do.

Suggested fix:
Edit /usr/lib/systemd/system/postgresql-15.service and change the
After=network.target line to
After=network-online.target

Right, although some authorities suggest also adding
Wants=network-online.target

In any case, that service file is not created or distributed by us.
I suggest filing this as a bug against the Fedora postgresql package.
			regards, tom lane