Search Postgresql Archives

Re: psql 8 warm standby strong start, weak finish

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> 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

Things are running smoothly so far.  The proof will be in the pudding after 48h or so.  But I have changed my rsync from its original pull approach to push.  I do need to clean up the WAL's on master once they've made it to the warm_standby, so in this new push approach, I only round up WAL's that are, say 10m old, and then rsync those to warm_standby, deleting them on master when they've been xferred.  warm_standby continues to do a good job of cleaning up the archive dir w/o any fuss from me. 


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux