大网数据广告活动
服务器运维问答

PostgreSQL: WAL files on server are not deleted

· 52CE 我爱测

Previously, the server was configured to hot_standby master. After a while he began to work alone. I changed the settings according to it, but the amount of WAL files is still growing ... How to get rid of it? OS - CentOS postgre…

问题原文

原帖链接 · Ishayahu · CC BY-SA 4.0

Previously, the server was configured to hot_standby master. After a while he began to work alone. I changed the settings according to it, but the amount of WAL files is still growing ...

How to get rid of it?

OS - CentOS

postgresql.conf:

listen_addresses = '192.168.1.24,localhost'     
max_connections = 100           
shared_buffers = 32MB           
wal_level = minimal         
archive_mode = off      
archive_command = 'test ! -f /var/lib/pgsql/docsrv/pgarch/%f && cp %p /var/lib/pgsql/docsrv/pgarch/%f'      
max_wal_senders = 1     
log_destination = 'syslog'
log_timezone = 'Europe/Samara'
update_process_title = off
datestyle = 'iso, mdy'
timezone = 'Europe/Samara'
lc_messages = 'C'           
lc_monetary = 'C'           
lc_numeric = 'C'            
lc_time = 'C'               
default_text_search_config = 'pg_catalog.english'

已采纳解答

原帖链接 · Jayadevan · CC BY-SA 3.0

Did you restart after changing the setting? Try

show wal_level;

and

show archive_mode;

at psql prompt

and try

show config_file;

to see which config file is used by the server

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2013-12-15)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0 / CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。