pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Dryden <tdryden@comcast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
Date: Mon, 2 Jan 2023 12:47:44 -0500
Message-ID: <91a563d0-5704-1f86-009d-3e70979c7090@comcast.net> (raw)
In-Reply-To: <1309910.1672614883@sss.pgh.pa.us>
References: <e6d2c602-db46-0709-6519-ade189fa5203@comcast.net>
	<1309910.1672614883@sss.pgh.pa.us>

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

view thread (5+ messages)  latest in thread

Message-ID: <91a563d0-5704-1f86-009d-3e70979c7090@comcast.net>
Permalink:  ../91a563d0-5704-1f86-009d-3e70979c7090@comcast.net/
Also on:    postgresql.org/message-id/91a563d0-5704-1f86-009d-3e70979c7090@comcast.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: tdryden@comcast.net, tgl@sss.pgh.pa.us
  Subject: Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
  In-Reply-To: <91a563d0-5704-1f86-009d-3e70979c7090@comcast.net>
  References: <e6d2c602-db46-0709-6519-ade189fa5203@comcast.net> <1309910.1672614883@sss.pgh.pa.us> <91a563d0-5704-1f86-009d-3e70979c7090@comcast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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