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
