On Jan 18, 2008, at 11:17 AM, Glyn Astill wrote:
My server ran out of disk space because my archive directory was full ow write ahead logs. My warm standby had lost it's mounted NFS volume and thus stopped reading in the archives from the master. Would I have run out of space if the standby hadn't stopped reading them in? I.e, should I be deleting the old logs myself or should the warm standby be managing them?
Depends on what you're using run your warm standby in your recovery.conf. pg_standby has the -k flag for NUMFILESTOKEEP. Where I work, we have a cron job that deletes WAL archives more than three days old. Admittedly, using pg_standby's -k option is probably more reliable.
Erik Jones DBA | Emma® erik@xxxxxxxxxx 800.595.4401 or 615.292.5888 615.292.0777 (fax) Emma helps organizations everywhere communicate & market in style. Visit us online at http://www.myemma.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
