Answer the question
In order to leave comments, you need to log in
How to reduce Wal in postgresql?
There is a server with bases 1s. There are not so many places, 80 gigs of disk and 10 for backup for wal magazines, not big 2 bases are spinning. Everything was fine from the beginning. Then Over time, the pg_wal directory began to grow. But then we figured it out, a log was being accumulated, which was not transferred to the disk for backup. Switched off and on archive_mode and the log began to be transferred to the backup disk. But the logs have accumulated for 40 gigs, and we have only 10, i.e. still not transferred.
The disk is now not enough and the question arose: is it possible to delete what was transferred to the backup and to unload the log so that it does not accumulate?
And you can somehow reduce the number of files for both backup and databases? Doesn't postgres need to keep that many logs?
Answer the question
In order to leave comments, you need to log in
Doesn't postgres need to keep that many logs?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question