Greg Clough Blog

Just a friendly FYI that AWS do not have access to any of your PostgreSQL RDS database logs, such as postgresql.log. This is important, if you just happen to hit PostgreSQL bug such as this one that was fixed in v11.3: Fix race conditions in management of dynamic shared memory (Thomas Munro) These could lead […]

An interesting (and currently undocumented) behaviour of PostgreSQL is that when there is an error writing to the postgresql.log configured in log_filename, that all future log rotations are disabled by this piece of code in syslogger.c: if (errno != ENFILE && errno != EMFILE) { ereport(LOG, (errmsg(“disabling automatic rotation (use SIGHUP to re-enable)”))); rotation_disabled = […]