On 11/20/2018 06:32 PM, George Anchev via Bacula-users wrote: > $ du -hs pg_wal/ > 769M pg_wal/ > $ psql -U postgres -d postgres -c checkpoint > CHECKPOINT > $ du -hs pg_wal/ > 769M pg_wal/
If it still hasn't gone down, check your postgresql.conf for
#wal_level = replica # minimal, replica, or logical
# (change requires restart)
If the above is what you have, you could change it to
wal_level = minimal
and restart.
FWIW I just checked another of out postgresql-10 hosts, this one does a
lot of truncates and loaded on a 10^6+ rows DB, it has
#max_wal_size = 1GB
and ~999.5MB in pg_wal when idle.
--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
