From: | Tom Dryden <tdryden(at)comcast(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL 15 on Fedora 37 Does not start after reboot |
Date: | 2023-01-02 17:47:44 |
Message-ID: | 91a563d0-5704-1f86-009d-3e70979c7090@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Fedora Bugzila report ID 2157651 has been submitted.
Thanks
Tom
On 1/1/23 18:14, Tom Lane wrote:
> 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 | Devrim Gündüz | 2023-01-02 17:56:15 | Re: PostgreSQL 15 on Fedora 37 Does not start after reboot |
Previous 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 |