From: Tom Dryden <tdryden@comcast.net>
To: pgsql-bugs@lists.postgresql.org
Subject: PostgreSQL 15 on Fedora 37 Does not start after reboot
Date: Sun, 1 Jan 2023 17:55:07 -0500
Message-ID: <e6d2c602-db46-0709-6519-ade189fa5203@comcast.net> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tdryden@comcast.net, pgsql-bugs@lists.postgresql.org
Subject: Re: PostgreSQL 15 on Fedora 37 Does not start after reboot
In-Reply-To: <e6d2c602-db46-0709-6519-ade189fa5203@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