[MacPorts] #68348: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed
MacPorts
noreply at macports.org
Wed Oct 4 03:36:23 UTC 2023
#68348: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed
----------------------------------+--------------------
Reporter: conradwt | Owner: (none)
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version:
Resolution: | Keywords:
Port: postgresql15-server |
----------------------------------+--------------------
Comment (by conradwt):
PostgreSQL 15 hasn't updated the existing logfile,
/opt/local/var/log/postgresql15/postgres.log, since 2 AM yesterday.
Here's the contents of that file:
{{{
2023-09-27 04:35:05.604 PDT [55565] LOG: starting PostgreSQL 15.4 on
aarch64-apple-darwin23.0.0, compiled by Apple clang version 15.0.0
(clang-1500.0.40.1), 64-bit
2023-09-27 04:35:05.605 PDT [55565] LOG: listening on IPv6 address "::1",
port 5432
2023-09-27 04:35:05.606 PDT [55565] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2023-09-27 04:35:05.606 PDT [55565] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"
2023-09-27 04:35:05.624 PDT [55568] LOG: database system was shut down at
2023-09-27 04:35:04 PDT
2023-09-27 04:35:05.628 PDT [55565] LOG: database system is ready to
accept connections
2023-09-27 04:40:05.630 PDT [55566] LOG: checkpoint starting: time
2023-09-27 04:40:05.636 PDT [55566] LOG: checkpoint complete: wrote 3
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s,
sync=0.001 s, total=0.007 s; sync files=2, longest=0.001 s, average=0.001
s; distance=0 kB, estimate=0 kB
2023-09-29 02:34:31.060 PDT [55565] LOG: received smart shutdown request
2023-09-29 02:34:31.290 PDT [55565] LOG: background worker "logical
replication launcher" (PID 55571) exited with exit code 1
2023-09-29 02:34:31.700 PDT [55566] LOG: shutting down
2023-09-29 02:34:31.703 PDT [55566] LOG: checkpoint starting: shutdown
immediate
2023-09-29 02:34:31.710 PDT [55566] LOG: checkpoint complete: wrote 0
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s,
sync=0.001 s, total=0.010 s; sync files=0, longest=0.000 s, average=0.000
s; distance=0 kB, estimate=0 kB
2023-09-29 02:34:31.720 PDT [55565] LOG: database system is shut down
2023-09-29 20:21:27.907 PDT [453] LOG: starting PostgreSQL 15.4 on
aarch64-apple-darwin23.0.0, compiled by Apple clang version 15.0.0
(clang-1500.0.40.1), 64-bit
2023-09-29 20:21:27.909 PDT [453] LOG: listening on IPv6 address "::1",
port 5432
2023-09-29 20:21:27.909 PDT [453] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2023-09-29 20:21:27.909 PDT [453] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"
2023-09-29 20:21:27.933 PDT [456] LOG: database system was shut down at
2023-09-29 02:34:31 PDT
2023-09-29 20:21:27.938 PDT [453] LOG: database system is ready to accept
connections
2023-09-29 20:26:27.848 PDT [454] LOG: checkpoint starting: time
2023-09-29 20:26:27.852 PDT [454] LOG: checkpoint complete: wrote 3
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s,
sync=0.001 s, total=0.005 s; sync files=2, longest=0.001 s, average=0.001
s; distance=0 kB, estimate=0 kB
2023-09-30 18:34:02.847 PDT [454] LOG: checkpoint starting: time
2023-09-30 18:35:37.573 PDT [454] LOG: checkpoint complete: wrote 937
buffers (5.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=94.705
s, sync=0.013 s, total=94.726 s; sync files=300, longest=0.001 s,
average=0.001 s; distance=4296 kB, estimate=4296 kB
2023-09-30 18:49:02.572 PDT [454] LOG: checkpoint starting: time
2023-09-30 18:49:05.915 PDT [454] LOG: checkpoint complete: wrote 34
buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.338 s,
sync=0.004 s, total=3.344 s; sync files=32, longest=0.001 s, average=0.001
s; distance=126 kB, estimate=3879 kB
2023-10-01 05:11:23.123 PDT [453] LOG: received smart shutdown request
2023-10-01 05:11:23.224 PDT [453] LOG: background worker "logical
replication launcher" (PID 459) exited with exit code 1
2023-10-01 05:11:23.606 PDT [454] LOG: shutting down
2023-10-01 05:11:23.609 PDT [454] LOG: checkpoint starting: shutdown
immediate
2023-10-01 05:11:23.619 PDT [454] LOG: checkpoint complete: wrote 1
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s,
sync=0.001 s, total=0.013 s; sync files=1, longest=0.001 s, average=0.001
s; distance=0 kB, estimate=3491 kB
2023-10-01 05:11:23.628 PDT [453] LOG: database system is shut down
2023-10-01 11:22:07.089 PDT [390] LOG: starting PostgreSQL 15.4 on
aarch64-apple-darwin23.0.0, compiled by Apple clang version 15.0.0
(clang-1500.0.40.1), 64-bit
2023-10-01 11:22:07.091 PDT [390] LOG: listening on IPv6 address "::1",
port 5432
2023-10-01 11:22:07.091 PDT [390] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2023-10-01 11:22:07.092 PDT [390] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"
2023-10-01 11:22:07.113 PDT [393] LOG: database system was shut down at
2023-10-01 05:11:23 PDT
2023-10-01 11:22:07.117 PDT [390] LOG: database system is ready to accept
connections
2023-10-01 11:27:07.134 PDT [391] LOG: checkpoint starting: time
2023-10-01 11:27:07.249 PDT [391] LOG: checkpoint complete: wrote 4
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s,
sync=0.004 s, total=0.115 s; sync files=3, longest=0.003 s, average=0.002
s; distance=0 kB, estimate=0 kB
2023-10-01 18:07:04.821 PDT [390] LOG: received smart shutdown request
2023-10-01 18:07:04.824 PDT [390] LOG: background worker "logical
replication launcher" (PID 396) exited with exit code 1
2023-10-01 18:07:04.824 PDT [391] LOG: shutting down
2023-10-01 18:07:04.825 PDT [391] LOG: checkpoint starting: shutdown
immediate
2023-10-01 18:07:04.830 PDT [391] LOG: checkpoint complete: wrote 0
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s,
sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000
s; distance=0 kB, estimate=0 kB
2023-10-01 18:07:04.837 PDT [390] LOG: database system is shut down
2023-10-01 18:07:35.477 PDT [382] LOG: starting PostgreSQL 15.4 on
aarch64-apple-darwin23.0.0, compiled by Apple clang version 15.0.0
(clang-1500.0.40.1), 64-bit
2023-10-01 18:07:35.479 PDT [382] LOG: listening on IPv6 address "::1",
port 5432
2023-10-01 18:07:35.479 PDT [382] LOG: listening on IPv4 address
"127.0.0.1", port 5432
2023-10-01 18:07:35.480 PDT [382] LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"
2023-10-01 18:07:35.500 PDT [385] LOG: database system was shut down at
2023-10-01 18:07:04 PDT
2023-10-01 18:07:35.504 PDT [382] LOG: database system is ready to accept
connections
2023-10-01 18:12:35.505 PDT [383] LOG: checkpoint starting: time
2023-10-01 18:12:35.517 PDT [383] LOG: checkpoint complete: wrote 3
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s,
sync=0.001 s, total=0.013 s; sync files=2, longest=0.001 s, average=0.001
s; distance=0 kB, estimate=0 kB
2023-10-02 02:08:17.204 PDT [382] LOG: received smart shutdown request
2023-10-02 02:08:17.206 PDT [382] LOG: background worker "logical
replication launcher" (PID 388) exited with exit code 1
2023-10-02 02:08:17.206 PDT [383] LOG: shutting down
2023-10-02 02:08:17.207 PDT [383] LOG: checkpoint starting: shutdown
immediate
2023-10-02 02:08:17.212 PDT [383] LOG: checkpoint complete: wrote 0
buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s,
sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000
s; distance=0 kB, estimate=0 kB
2023-10-02 02:08:17.219 PDT [382] LOG: database system is shut down
}}}
--
Ticket URL: <https://trac.macports.org/ticket/68348#comment:2>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list