Re: psql 8 warm standby strong start, weak finish

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Charlton Galvarino <charlton(at)2creek(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql 8 warm standby strong start, weak finish
Date: 2015-04-30 14:43:46
Message-ID: 55423FA2.3080808@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2015-04-30 17:08:19 Re: newsfeed type query
Previous Message Charlton Galvarino 2015-04-30 14:42:14 Re: psql 8 warm standby strong start, weak finish