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
