Re: hot standby, how to disable WAL archiving ?

[John Scalia <jayknowsunix@xxxxxxxxx>]

Hi Roman,

Maybe one of the developers can chime in on this, but to my knowledge, as at least one WAL file should be available for the server to successfully start, you can't turn these off entirely. My suggestion would be to set wal_keep_segments to a much smaller number, even "1", Also, did you change the default size of the WAL segments? I can't actually remember the exact name for this parameter, but the default is 16MB. You can have this set to a much larger value.

--

Jay

On Tue, Sep 29, 2015 at 6:01 PM, Roman Shubovich <r.shubovich@xxxxxxxxx> wrote:

hi

I've up master-slave streaming replication.

each host have RAM tmpfs disk for WAL files with 5BG space, and my config is:

wal_keep_segments = 64

checkpoint_segments = 32

checkpoint_timeout = 1h

checkpoint_completion_target = 0.8

WAL archiving is off

master host works as expected - he keeps about 140-160 files in the pg_xlog folder

but standby host ignore the config, he won't remove old wal files and in archive_status folder I can see many xxxxxx.done files, but archiving is not enabled.

how can I disable that behavior ?

I already tried playing with archive_cleanup_command, recovery_end_command, pg_archivecleanup - nothing helped.

when standby host operate as master server then no problems occurs

postgres version 9.4.4, compiled from source

OS ubuntu 14.04.3