Re: Disk is filling up with large files. How can I clean?

Another possibility is orphaned files. See https://www.dbi-services.com/blog/can-there-be-orphaned-data-files-in-postgresql/ and https://github.com/bdrouvot/pg_orphaned -- Sergey On Wed, 9 Oct 2024 at 19:02, Greg Sabino Mullane wrote: > > On Wed, Oct 9, 2024 at 4:10 AM Mikael Petterson > wrote

Re: Orphan files filling root partition after crash

Hi Dimitrios, Do you have wal archiving enabled? $PGDATA/pg_wal/ is a bit different from tablespaces (including "default" one). It stores transaction journal. Instructions are here: https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-ARCHIVING-WAL Some more info here: https://w

Re: regex failing

On Tue, 27 Jun 2023 at 14:59, Zahir Lalani wrote: > > Hi All > > > > Got a weird one. I am using the regex below to case match numeric only values. > > > > '^([0-9]+[.]?[0-9]*)$' > > > > This works well by and large but not for a value like “1234:567”. This seems > to match positive and then fail