Re: psql 8 warm standby strong start, weak finish - Mailing list pgsql-general

From Adrian Klaver
Subject Re: psql 8 warm standby strong start, weak finish
Date
Msg-id 55423FA2.3080808@aklaver.com
Whole thread Raw
In response to Re: psql 8 warm standby strong start, weak finish  (Charlton Galvarino <charlton@2creek.com>)
Responses Re: psql 8 warm standby strong start, weak finish
List pgsql-general
On 04/30/2015 07:42 AM, Charlton Galvarino wrote:
>> Hmm, in newer versions of rsync  --remove-sent-files has been replaced by --
>> remove-source-files, so I cannot test. Some searching found that --remove-
>> sent-files will move/delete unfinished files. I would say that the above cron
>> command is dangerous. To test, comment out the command and let the
>
> Great idea.  Will do and let it run for a few days.
>
>> archiving run. Postgres will recycle WALs on its own when they are no longer
>> needed. Or is there is some compelling reason you want to get rid of WALs?
>
> Ah.  I didn't know that.  I thought the cleanup was on me.  Bonus!

For more info take a look here:

http://www.postgresql.org/docs/8.4/static/wal-configuration.html

>
> Thanks for the help.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Charlton Galvarino
Date:
Subject: Re: psql 8 warm standby strong start, weak finish
Next
From: Meel Velliste
Date:
Subject: Finding new or modified rows since snapshot