Re: Postgresql database terminates abruptly with too many open files error

2025-01-14 Thread Frank Lanitz
Hello, Have you checked something like lsof to see open file descriptors to see? Cheers, frank Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili: Hello Team,  We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to too many open files". Below are few alerts that w

Re: pgBadger: Cannot find any log entries from systemd-journald

2024-03-12 Thread Frank Lanitz
Hello, Sorry for the late response. Am 06.03.24 um 16:40 schrieb Greg Sabino Mullane: On Tue, Mar 5, 2024 at 3:14 AM Frank Lanitz mailto:fr...@frank.uvena.de>> wrote: $ pgbadger --journalctl "journalctl -u postgresql.service" You could try adding --verbose to see if it

pgBadger: Cannot find any log entries from systemd-journald

2024-03-05 Thread Frank Lanitz
Hello, I think I just might did a small configuration issue, but somehow I cannot figure it out by myself. I want to let pgbadger directly fetch data from journald -- so I was using with a unexpected outcome: $ pgbadger --journalctl "journalctl -u postgresql.service" LOG: Ok, generating html