Re: How to prevent master server crash if hot standby stops

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