Re: SystemD Unit file missing "After=network-online.target" Parameter - Mailing list pgsql-bugs

From Christoph Berg
Subject Re: SystemD Unit file missing "After=network-online.target" Parameter
Date
Msg-id 20180907143718.GF29573@msg.df7cb.de
Whole thread Raw
In response to SystemD Unit file missing "After=network-online.target" Parameter  (Sebastian Elisa Pfeifer <s.pfeifer@ixolit.com>)
Responses Re: [BUGS] BUG #13793: Please implement IP_FREEBIND option  (Christoph Berg <myon@debian.org>)
List pgsql-bugs
Re: Sebastian Elisa Pfeifer 2018-09-07 <ab23ab6a-f54a-4063-be3d-dbc93f5dedd2@ixolit.com>
> |2018-09-06 14:02:32 UTC LOG: could not bind IPv4 socket: Cannot assign
> requested address 2018-09-06 14:02:32 UTC HINT: Is another postmaster
> already running on port 5432? If not, wait a few seconds and retry.
> 2018-09-06 14:02:32 UTC WARNING: could not create listen socket for
> "123.123.123.123"|
> 
> Possible fix: Adding the parameter After=network-online.target to it's
> SystemD Unit file.
> 
> Our setup includes the setting:
> listen_addresses = 'localhost,123.123.123.123' (not the real IP)

Hi,

thanks for the report.

I'll have to investigate if that's the correct fix in general. Afaict
network-online.target does less than what the name says, i.e. some
interfaces might still be configuring even at that point. Usual
symptoms are IPv6 devices that are still in address discovery.

I'll let you know what the outcome is.

Christoph


pgsql-bugs by date:

Previous
From: Sebastian Elisa Pfeifer
Date:
Subject: SystemD Unit file missing "After=network-online.target" Parameter
Next
From: PG Bug reporting form
Date:
Subject: BUG #15368: using pgadmin 4 to change any characteristic of a numericfield of a table.