Re: Issue with WAL files in streaming replication

From: Ibrahim Edib Kokdemir <kokdemir(at)gmail(dot)com>
To: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Issue with WAL files in streaming replication
Date: 2018-01-08 06:40:08
Message-ID: CABnTomLP4gEkmta9rSpYh0Dz1DQsRSh_4ak32NkXGATb0BLd-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
> On Mon, Jan 8, 2018 at 8:40 AM, Leroy Tennison <leroy_tennison(at)prodigy(dot)net
> > wrote:
>
>> I have attempted to set up a Postgres 9.5 server as a streaming
>> replication backup (guessing my way through the process after reading the
>> Postgresql documentation and a few tutorials) but am running into an
>> issue. The WAL archive files are not being removed on the backup. I'm
>> wondering if everything is OK and I should have discontinued the WAL
>> archive process or if something else is wrong. Thanks for any help. The
>> following should be the relevant configuration.
>>
>

you should see a recovery.conf in slave server and below line must be
included in that file to delete old archive files.

archive_cleanup_command = '/path/to/pg_archivecleanup /path/to/archive/dir
%r'

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message flumbador 2018-01-08 13:53:20 Re: Issue on restore / recover
Previous Message Shreeyansh Dba 2018-01-08 05:56:14 Re: Issue with WAL files in streaming replication