Re: hot standby, how to disable WAL archiving ?

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(dot)shubovich(at)gmail(dot)com>
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
>