SystemD Unit file missing "After=network-online.target" Parameter

From: Sebastian Elisa Pfeifer <s(dot)pfeifer(at)ixolit(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: SystemD Unit file missing "After=network-online.target" Parameter
Date: 2018-09-07 10:38:04
Message-ID: ab23ab6a-f54a-4063-be3d-dbc93f5dedd2@ixolit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,
In the environment

Kernel: Linux use-prod-web01 4.9.0-8-amd64 #1 SMP Debian
4.9.110-3+deb9u4 (2018-08-21) x86_64 GNU/Linux
OS: Debian 9 stretch
PostgreSQL: 9.3.23-2.pgdg90+1

Expected behavior: Postgres starting and binding to the external interface.

Actual behavior: Otherwise Postgres fails to bind to the external
interface at reboots randomly with the following error message:

|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)

Do not hesitate to contact me/us with further questions.

All the best
Sebastian

--
*Sebastian Elisa Pfeifer* :: System Administrator
IXOLIT GmbH <https://www.ixolit.com>
Mariahilfer Straße 77-79 :: A-1060, Vienna
tel +43-1-3530505 <tel:+4313530505> :: fax +43-1-3530505-30
web www.ixolit.com <https://www.ixolit.com>
Linkedin <https://www.linkedin.com/company/1707775> Facebook
<https://www.facebook.com/ixolit> Twitter <https://twitter.com/ixolit>
Google+ <https://plus.google.com/+IxolitGmbHWien> GitHub
<https://github.com/ixolit>

CONFIDENTIALITY NOTICE:
The information contained in this communication, including attachments,
is confidential and intended only for the exclusive use of the
addressee. If the reader of this message is not the intended recipient,
or the employee or agent responsible for delivering it to the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us by telephone
immediately. Thank you.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christoph Berg 2018-09-07 14:37:18 Re: SystemD Unit file missing "After=network-online.target" Parameter
Previous Message Noah Misch 2018-09-07 06:05:04 Re: PostgreSQL