Wal files in /pgsql/14/main/pg_wal not removed

2021-12-26 Thread Lucas
Hi guys, and happy holidays. My /pgsql/14/main/pg_wal directory is filling up. The server is not respecting the wal_keep_size = 100GB. I have no replication slots in this server, and I have already restarted PostgreSQL. I don’t know what else to look for. Would appreciate any help. My postgre

Re: storing zipped SQLite inside PG ?

2021-12-26 Thread amihay gonen
Is sqlite is a constraint? >From big data presctive is better to find a more natural format like parquet or even json. For example what if you've different sqlite version בתאריך יום ה׳, 23 בדצמ׳ 2021, 17:02, מאת Дмитрий Иванов ‏< firstdis...@gmail.com>: > Or, if you want to extend this theme, yo

Re: Wal files in /pgsql/14/main/pg_wal not removed

2021-12-26 Thread Tom Lane
Lucas writes: > My /pgsql/14/main/pg_wal directory is filling up. The server is not > respecting the wal_keep_size = 100GB. I have no replication slots in this > server, and I have already restarted PostgreSQL. > I don’t know what else to look for. Would appreciate any help. > archive_mode = o

Re: Wal files in /pgsql/14/main/pg_wal not removed

2021-12-26 Thread Lucas
> On 27/12/2021, at 5:14 AM, Tom Lane wrote: > > Lucas writes: >> My /pgsql/14/main/pg_wal directory is filling up. The server is not >> respecting the wal_keep_size = 100GB. I have no replication slots in this >> server, and I have already restarted PostgreSQL. >> I don’t know what else to