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
