| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to prevent master server crash if hot standby stops |
| Date: | 2020-04-07 10:50:41 |
| Message-ID: | b12b2e2f498dba4209ba022488e3caf8342d39e6.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vano Beridze | 2020-04-07 11:39:27 | PostgreSQL native multi-master |
| Previous Message | Thomas Munro | 2020-04-07 10:25:48 | Re: EINTR while resizing dsm segment. |