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®
[EMAIL PROTECTED]
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/
