Grokbase › Groups › PostgreSQL › pgsql-general › January 2008
FAQ
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?


___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/

Search Discussions

  • Darcy Buskermolen at Jan 18, 2008 at 6:18 pm ⇧

    On Friday 18 January 2008 09:17:10 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?
    either delete them yourself, use a cron job to delete them (something like
    find . -mtime 60 -delete) , or if you are using pg_standby look at -k (which
    specifies the number of old files to keep

    ___________________________________________________________
    Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
    now.
    http://uk.answers.yahoo.com/


    ---------------------------(end of broadcast)---------------------------
    TIP 1: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to majordomo@postgresql.org so that your
    message can get through to the mailing list cleanly


    --
    Darcy Buskermolen
    Command Prompt, Inc.
    +1.503.667.4564 X 102
    http://www.commandprompt.com/
    PostgreSQL solutions since 1997
  • Erik Jones at Jan 18, 2008 at 6:31 pm ⇧

    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@myemma.com
    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
  • Glyn Astill at Jan 18, 2008 at 6:53 pm ⇧
    Thanks Erik,

    I'll set up a cron job to remove them for now, however I'll have a
    look at pg_standby


    --- Erik Jones wrote:
    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@myemma.com
    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




    __________________________________________________________
    Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
  • Tom Lane at Jan 18, 2008 at 8:34 pm ⇧

    Glyn Astill writes:
    I'll set up a cron job to remove them for now, however I'll have a
    look at pg_standby
    Keep in mind that if you delete a log segment that's not yet been sent
    to the standby, you've hosed the standby --- you'll have to take a fresh
    base backup and reload the standby with it. This is probably okay for
    disaster recovery, but you don't want your script creating the disaster
    all by itself.

    regards, tom lane
  • Erik Jones at Jan 18, 2008 at 8:52 pm ⇧

    On Jan 18, 2008, at 2:34 PM, Tom Lane wrote:

    Glyn Astill <glynastill@yahoo.co.uk> writes:
    I'll set up a cron job to remove them for now, however I'll have a
    look at pg_standby
    Keep in mind that if you delete a log segment that's not yet been sent
    to the standby, you've hosed the standby --- you'll have to take a
    fresh
    base backup and reload the standby with it. This is probably okay for
    disaster recovery, but you don't want your script creating the
    disaster
    all by itself.
    Which is exactly why I pointed out that using pg_standby's -k switch
    was the more reliable option.

    Erik Jones

    DBA | Emma®
    erik@myemma.com
    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
  • David Wall at Jan 18, 2008 at 11:17 pm ⇧

    Which is exactly why I pointed out that using pg_standby's -k switch
    was the more reliable option.
    And supposedly even that switch is not needed once we can get to 8.3,
    which should be soon. Even the -k switch can be an issue since you
    don't really know how many you should keep around.

    David

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJan 18, '08 at 5:36p
activeJan 18, '08 at 11:17p
posts7
users5
websitepostgresql.org
irc#postgresql

5 users in discussion

Glyn Astill: 2 posts Erik Jones: 2 posts Darcy Buskermolen: 1 post David Wall: 1 post Tom Lane: 1 post

Content

People

Support

Translate

site design / logo © 2022 Grokbase