On Tue, 2020-01-21 at 11:18 +0100, Ekaterina Amez wrote:

[about wal_keep_segments]

> I'm not sure how to figure this value . Of course I could use a big 
> value and forget, but as the server is running out of space I'd like to 
> adjust it so there is (almost) no waste of space. This is why I began to 
> think about wal archiving, though it seems a bit more complicated.

See how many WAL files are generated in a day.

If you set wal_keep_segments to that value, the standby will be
able to survive a down time of a day.

If you don't need to cater for that much down time, use a smaller value.

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



Reply via email to