| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | tdryden(at)comcast(dot)net |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL 15 on Fedora 37 Does not start after reboot |
| Date: | 2023-01-01 23:14:43 |
| Message-ID: | 1309910.1672614883@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Tom Dryden <tdryden(at)comcast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandeep Thakkar | 2023-01-02 04:46:12 | Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl |
| Previous Message | Tom Dryden | 2023-01-01 22:55:07 | PostgreSQL 15 on Fedora 37 Does not start after reboot |