Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2014
    Posts
    20

    Unanswered: WAL management w/streaming replication

    Hi all,

    On a version 9.3.3 streaming replication standby server where there is a log arching directory written by the primary server, there does not appear to be any mechanism to remove old WAL files in the archive directory which really aren't needed any more. Obviously with streaming, these WAL files are just insurance, and really have no need to hang around, but did I just miss the utility or setting to manage these, or could I set up a cron task to remove them if "x" hours old?

    I'm not finding anything to help me manage disk space,
    Jay

  2. #2
    Join Date
    Mar 2014
    Posts
    17
    Quote Originally Posted by jay at Verizon View Post
    Hi all,

    On a version 9.3.3 streaming replication standby server where there is a log arching directory written by the primary server, there does not appear to be any mechanism to remove old WAL files in the archive directory which really aren't needed any more. Obviously with streaming, these WAL files are just insurance, and really have no need to hang around, but did I just miss the utility or setting to manage these, or could I set up a cron task to remove them if "x" hours old?

    I'm not finding anything to help me manage disk space,
    Jay
    WHats ur values for "WAL_SYNC_METHOD" and WAL_LEVEL ?

  3. #3
    Join Date
    Mar 2014
    Posts
    20
    Both servers (primary and standby):

    wal_sync_method = fdatasync # this is linux default
    wal_level = hot_standby

    --
    Jay

  4. #4
    Join Date
    Mar 2014
    Posts
    17
    Quote Originally Posted by jay at Verizon View Post
    Both servers (primary and standby):

    wal_sync_method = fdatasync # this is linux default
    wal_level = hot_standby

    --
    Jay
    Go through this link , it might help you PostgreSQL: Documentation: 9.2: Reliability

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •