On Tue, 2020-04-07 at 12:05 +0300, Andrus wrote: > > About your third question, you *never* manually mess with the files in pg_wal. > > The server does that. > > Is it OK to stop server, delete all files in pg_wal directory and re-start server ? No. > Or should default value put back and wait until server frees 1 GB disk space ? You'd have to set "wal_keep_segments" and "max_wal_size" lower, then have normal database activity and wait until a couple of checkpoints have passed. But frankly, 1 GB is ridiculously little. If you have to worry about that much disk space, you're must be running PostgreSQL on a toaster. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
