Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC7FZ-0005cB-7m for pgsql-bugs@arkaria.postgresql.org; Sun, 01 Jan 2023 22:56:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pC7FX-0008VW-JT for pgsql-bugs@arkaria.postgresql.org; Sun, 01 Jan 2023 22:56:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC7FW-0008VL-N2 for pgsql-bugs@lists.postgresql.org; Sun, 01 Jan 2023 22:56:15 +0000 Received: from resqmta-a1p-077436.sys.comcast.net ([2001:558:fd01:2bb4::2]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC7FQ-0007ua-EG for pgsql-bugs@lists.postgresql.org; Sun, 01 Jan 2023 22:56:13 +0000 Received: from resomta-a1p-076781.sys.comcast.net ([96.103.145.226]) by resqmta-a1p-077436.sys.comcast.net with ESMTP id C6Y8pMHeodaYlC7FHpO6jX; Sun, 01 Jan 2023 22:55:59 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net; s=20190202a; t=1672613759; bh=zZmqxrD6d1m7QCR2UmtQTDn8zfDH5LVRgEC5SrcCQ9I=; h=Received:Received:Content-Type:Message-ID:Date:MIME-Version:To: Reply-To:From:Subject:Xfinity-Spam-Result; b=V9ntwpkhL0FMcp6VRhj76Nr6wUL+R4/buCTqlOGF960rW/V51gh7bp6Qp2M3Pc7W0 8IQcEKmoX+GYWyXI0hkxEziRIX0WWzyFN2vBqERN8JZJY8Vg2ymTBIZ0nK6lN2OG2Y S7ypsmQo+CQ5KQEQEIahlyh4LA+I2sw2IbLtAPTfq/o00jOtMj5FjMIV4JCBpuMMet EassfDhhFQkeuXTB7AhIXsehhjy6Njc4kQ19eM7Yj2IgwauvCmZZuU8UyURsuRFp1c 4mpj4DdasM6NYvB+ahkELrNmFE1x5VEjVB5WUZjWH8ka4XbPr1DnYd22KUdk/YG59t gH8vxg7XWQtbQ== Received: from [192.168.1.227] ([68.43.246.244]) by resomta-a1p-076781.sys.comcast.net with ESMTPSA id C7ERpGgGx2UlWC7Etpa2fA; Sun, 01 Jan 2023 22:55:35 +0000 X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgedvhedrjedugddtudcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddunecunecujfgurheptgfkffggfgfvrhfhufesrgdtreertdefjeenucfhrhhomhepvfhomhcuffhrhiguvghnuceothgurhihuggvnhestghomhgtrghsthdrnhgvtheqnecuggftrfgrthhtvghrnhepkeffveetgfekkeeuffevffekkeffteefleeljeetfeduhedvudefveehfeejgefgnecukfhppeeikedrgeefrddvgeeirddvgeegnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehhvghloheplgduledvrdduieekrddurddvvdejngdpihhnvghtpeeikedrgeefrddvgeeirddvgeegpdhmrghilhhfrhhomhepthgurhihuggvnhestghomhgtrghsthdrnhgvthdpnhgspghrtghpthhtohepuddprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-Xfinity-VMeta: sc=0.00;st=legit Content-Type: multipart/alternative; boundary="------------BlRV6JFxnnMp924ihNHCTUn7" Message-ID: Date: Sun, 1 Jan 2023 17:55:07 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.6.0 To: pgsql-bugs@lists.postgresql.org Reply-To: tdryden@comcast.net Content-Language: en-US From: Tom Dryden Subject: PostgreSQL 15 on Fedora 37 Does not start after reboot List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------BlRV6JFxnnMp924ihNHCTUn7 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 --------------BlRV6JFxnnMp924ihNHCTUn7 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

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


--------------BlRV6JFxnnMp924ihNHCTUn7--