Sample Header Ad - 728x90

How to calculate quantity of WAL in db without archiving?

0 votes
1 answer
706 views
I would like to find out a quantity of WAL files which are being used in PostgreSQL database in last 24h. I was assigned to do Log-shipping but before I do it I want to know how many WAL files are being used in last 24hours in order to predict how much space I need on external storage. Unfortunately pgmetrics doesn't have such information. Do you know how to do it? WAL Files: WAL Archiving? no WAL Files: 5 +--------------------+--------------+ | Setting | Value | +--------------------+--------------+ | wal_level | minimal | | archive_timeout | 0 | | wal_compression | off | | max_wal_size | 64 (1.0 GiB) | | min_wal_size | 5 (80 MiB) | | checkpoint_timeout | 300 | | full_page_writes | on | | wal_keep_segments | 0 | +--------------------+--------------+
Asked by KUE (25 rep)
May 29, 2019, 12:22 PM
Last activity: Dec 30, 2024, 12:00 PM