pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 15 on Fedora 37 Does not start after reboot
5+ messages / 3 participants
[nested] [flat]
* PostgreSQL 15 on Fedora 37 Does not start after reboot
@ 2023-01-01 22:55 Tom Dryden <tdryden@comcast.net>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Dryden @ 2023-01-01 22:55 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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
2023-01-01 09:22:26.406 EST [812] WARNING: could not create listen
socket for "192.168.122.124"
2023-01-01 09:22:26.406 EST [812] FATAL: could not create any TCP/IP sockets
2023-01-01 09:22:26.417 EST [812] LOG: database system is shut down
Suggested fix:
Edit /usr/lib/systemd/system/postgresql-15.service and change the
After=network.target line to
After=network-online.target
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
@ 2023-01-01 23:14 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tom Dryden <tdryden@comcast.net>
0 siblings, 2 replies; 5+ messages in thread
From: Tom Lane @ 2023-01-01 23:14 UTC (permalink / raw)
To: tdryden@comcast.net; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
@ 2023-01-02 17:47 Tom Dryden <tdryden@comcast.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Dryden @ 2023-01-02 17:47 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org
Fedora Bugzila report ID 2157651 has been submitted.
Thanks
Tom
On 1/1/23 18:14, Tom Lane wrote:
> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
@ 2023-01-02 17:56 Devrim Gündüz <devrim@gunduz.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 5+ messages in thread
From: Devrim Gündüz @ 2023-01-02 17:56 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; tdryden@comcast.net; +Cc: pgsql-bugs@lists.postgresql.org
Hi,
On Sun, 2023-01-01 at 18:14 -0500, Tom Lane wrote:
> 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.
This is PGDG RPMs (based on the unit file name). Pushed a fix:
https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=b0d12f55ba4e0301137e51f7cda1f6ceb1448cd6
I'm inclined to hold this until next month's updates, as there is
already a workaround.
Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
@ 2023-01-02 18:08 Tom Lane <tgl@sss.pgh.pa.us>
parent: Devrim Gündüz <devrim@gunduz.org>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2023-01-02 18:08 UTC (permalink / raw)
To: Devrim Gündüz <devrim@gunduz.org>; +Cc: tdryden@comcast.net; pgsql-bugs@lists.postgresql.org
Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= <devrim@gunduz.org> writes:
> On Sun, 2023-01-01 at 18:14 -0500, Tom Lane wrote:
>> I suggest filing this as a bug against the Fedora postgresql package.
> This is PGDG RPMs (based on the unit file name). Pushed a fix:
Ah, thanks.
> I'm inclined to hold this until next month's updates, as there is
> already a workaround.
Agreed. I think this is not a problem if listen_addresses is "*"
or "localhost", so it probably doesn't affect all that many people.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-01-02 18:08 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-01 22:55 PostgreSQL 15 on Fedora 37 Does not start after reboot Tom Dryden <tdryden@comcast.net>
2023-01-01 23:14 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-01-02 17:47 ` Tom Dryden <tdryden@comcast.net>
2023-01-02 17:56 ` Devrim Gündüz <devrim@gunduz.org>
2023-01-02 18:08 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox