On 10/10/21 2:20 PM, Tom Lane wrote:
Ron <ronljohnso...@gmail.com> writes:
I think Anil mentioned that there's *nothing* in the Postgresql server log,
even (in my case) with log_min_messages cranked to debug5.
I'm skeptical that you're looking in the right place, then.
What do you get from
show log_destination;
show log_directory;
This is AWS RDS Postgresql. The db server log is accessed via a web
interface, and is /the/ postgresql log just like you see in vanilla Postgresql.
I've attached it. My attempt to connect happened some time between between
04:10:30 and 04:17:30.
regards, tom lane
--
Angular momentum makes the world go 'round.
2021-10-03 04:01:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:01:30 UTC::@:[1721]:LOG: checkpoint complete: wrote 235 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=23.706 s, sync=0.004 s, total=23.733 s; sync files=73, longest=0.004 s, average=0.001 s; distance=66469 kB, estimate=68389 kB
2021-10-03 04:06:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:10:21 UTC::@:[1714]:LOG: received SIGHUP, reloading configuration files
2021-10-03 04:10:21 UTC::@:[1714]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1714]:LOG: parameter "log_min_error_statement" changed to "debug5"
2021-10-03 04:10:21 UTC::@:[1719]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1723]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1727]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1722]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1726]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1724]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1725]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:21 UTC::@:[1721]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:10:36 UTC::@:[1721]:LOG: checkpoint complete: wrote 6166 buffers (0.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.121 s, sync=0.008 s, total=269.152 s; sync files=172, longest=0.008 s, average=0.001 s; distance=64636 kB, estimate=68014 kB
2021-10-03 04:16:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:16:12 UTC::@:[1721]:LOG: checkpoint complete: wrote 56 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=5.788 s, sync=0.007 s, total=5.816 s; sync files=39, longest=0.004 s, average=0.001 s; distance=130865 kB, estimate=130865 kB
2021-10-03 04:17:40 UTC::@:[1714]:LOG: received SIGHUP, reloading configuration files
2021-10-03 04:17:40 UTC::@:[1714]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1714]:LOG: parameter "log_min_error_statement" changed to "info"
2021-10-03 04:17:40 UTC::@:[1719]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1724]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1723]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1722]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1726]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1725]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1721]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:17:40 UTC::@:[1727]:LOG: skipping missing configuration file "/rdsdbdata/config/recovery.conf"
2021-10-03 04:21:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:21:07 UTC::@:[1721]:LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.958 s, sync=0.006 s, total=0.986 s; sync files=5, longest=0.006 s, average=0.002 s; distance=65543 kB, estimate=124333 kB
2021-10-03 04:26:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:26:28 UTC::@:[1721]:LOG: checkpoint complete: wrote 215 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=21.796 s, sync=0.006 s, total=21.823 s; sync files=117, longest=0.006 s, average=0.001 s; distance=65729 kB, estimate=118473 kB
2021-10-03 04:31:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:31:29 UTC::@:[1721]:LOG: checkpoint complete: wrote 230 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=23.305 s, sync=0.013 s, total=23.339 s; sync files=89, longest=0.013 s, average=0.001 s; distance=65945 kB, estimate=113220 kB
2021-10-03 04:36:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:36:26 UTC::@:[1721]:LOG: checkpoint complete: wrote 199 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=20.187 s, sync=0.006 s, total=20.214 s; sync files=84, longest=0.003 s, average=0.001 s; distance=65478 kB, estimate=108446 kB
2021-10-03 04:41:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:41:21 UTC::@:[1721]:LOG: checkpoint complete: wrote 144 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=14.647 s, sync=0.005 s, total=14.672 s; sync files=77, longest=0.005 s, average=0.001 s; distance=65133 kB, estimate=104114 kB
2021-10-03 04:46:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:46:33 UTC::@:[1721]:LOG: checkpoint complete: wrote 261 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=26.426 s, sync=0.004 s, total=26.457 s; sync files=140, longest=0.004 s, average=0.001 s; distance=65678 kB, estimate=100271 kB
2021-10-03 04:51:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:51:21 UTC::@:[1721]:LOG: checkpoint complete: wrote 150 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=15.252 s, sync=0.007 s, total=15.279 s; sync files=69, longest=0.006 s, average=0.001 s; distance=65318 kB, estimate=96775 kB
2021-10-03 04:56:06 UTC::@:[1721]:LOG: checkpoint starting: time
2021-10-03 04:56:24 UTC::@:[1721]:LOG: checkpoint complete: wrote 177 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=17.972 s, sync=0.006 s, total=17.999 s; sync files=72, longest=0.006 s, average=0.001 s; distance=66034 kB, estimate=93701 kB
