From: | Tom Dryden <tdryden(at)comcast(dot)net> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | PostgreSQL 15 on Fedora 37 Does not start after reboot |
Date: | 2023-01-01 22:55:07 |
Message-ID: | e6d2c602-db46-0709-6519-ade189fa5203@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-01-01 23:14:43 | Re: PostgreSQL 15 on Fedora 37 Does not start after reboot |
Previous Message | Frank Reppin | 2022-12-29 22:09:48 | Re: BUG #17733: ERROR: could not load library "/Users/frank/postgres/postgresql-13.9/lib/postgresql/llvmjit.so": dl |