Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 2020-04-06 at 11:03 +0300, Andrus wrote:
> Streaming asynchronous binary replication is used with hot standby slave.
> 
> If slave stops responing, master server will create files in pg_wal directory.
> If disk becomes full, master server crashes also.
> 
> How to avoid this ?
> 
> If disk is nearly full, master should stop additional files creation (and maybe stop or disable replication slot).
> Postgres 12 in Debian 10 is used.

That's why you use monitoring.

Never use replication slots without monitoring replication (or at least the
disk space on the primary).

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux