pg_xlog on a hot_stanby slave

From: Xavier 12 <maniatux(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_xlog on a hot_stanby slave
Date: 2015-06-16 08:55:11
Message-ID: CAMOV8iB3oRzC4f7UTzOwC2wT08do3voi+PGN07uJq+ayo9E=cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Hi everyone,

Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).

Psql01 (master) is backuped with Barman and pg_xlogs is correctly
purged (archive_command is used).

Hower, Psql02 (slave) has a huge pg_xlog (951 files, 15G for 7 days
only, it keeps growing up until disk space is full). I have found
documentation and tutorials, mailing list, but I don't know what is
suitable for a Slave. Leads I've found :

- checkpoints
- archive_command
- archive_cleanup

Master postgresq.conf :

[...]
wal_level = 'hot_standby'
archive_mode = on
archive_command = 'rsync -az /var/lib/postgresql/9.1/main/pg_xlog/%f
barman(at)nas(dot)lan:/data/pgbarman/psql01/incoming/%f'
max_wal_senders = 5
wal_keep_segments = 64
autovacuum = on

Slave postgresql.conf :

[...]
wal_level = minimal
wal_keep_segments = 32
hot_standby = on

Slave recovery.conf :

standby_mode = 'on'
primary_conninfo = 'host=10.0.0.1 port=5400 user=postgres'
trigger_file = '/var/lib/postgresql/9.1/triggersql'
restore_command='cp /var/lib/postgresql/9.1/wal_archive/%f "%p"'
archive_cleanup_command =
'/usr/lib/postgresql/9.1/bin/pg_archivecleanup
/var/lib/postgresql/9.1/wal_archive/ %r'

How can I reduce the number of WAL files on the hot_stanby slave ?

Thanks

Regards.

Xavier C.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Guillaume Lelarge 2015-06-16 10:41:06 Re: pg_xlog on a hot_stanby slave
Previous Message Sergi Casbas 2015-06-16 08:40:03 Re: BUG #13444: psql can't recover a pg_dump.

Browse pgsql-general by date

  From Date Subject
Next Message Sylvain MARECHAL 2015-06-16 10:40:16 Re: BDR: Can a node live alone after being detached
Previous Message Albe Laurenz 2015-06-16 08:24:29 Re: Compression function