SG UTM

Suggest, discuss, and vote on new ideas for SG UTM. The ultimate network security package.

Suggest an Idea...

Don't Keep Write Ahead Logs (WALs) in Non-clustered Installations

By default, the Sophos UTM (Astaro) PostreSQL configuration is configured with High Availability (HA) settings enabled irrespective of whether a HA license is installed and/or two or more devices are installed. One of these settings, wal_keep_segments, has been set to a value of 100 ever since Sophos UTM version 9.100-16 and since each Write Ahead Log (WAL) segment is 16MB, this results in a extra 1.6GB of disk space being consumed unnecessarily. The default value for wal_keep_segments is 0 and setting it to this value before starting the PostgreSQL service prevents it from keeping any new WAL segments. I have been manually changing this setting to 0 since the release of 9.100-16 and also set hot_standby to off in the postgresql.conf.* files located in /var/storage/psql92/cfg/, which appears under /dest/ when performing a fresh install and using ALT-F2 to switch to the console before rebooting at the end of the installation. For further details, see the following StackOverflow post:

How can I request a flush of the postgresql transaction logs? - Database Administrators Stack Exchange
http://dba.stackexchange.com/questions/43011/how-can-i-request-a-flush-of-the-postgresql-transaction-logs

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base

      icon-data-protection icon-endpoint-protection icon-phish-threat icon-sophos-central icon-sophos-central icon-sophos-central icon-sophos-central icon-sophos-central icon-sophos-central icon-sophos-central icon-sophos-mobile icon-sophos-utm icon-sophos-utm icon-sophos-utm icon-web-appliance icon-xg-firewall icon-xg-firewall icon-lightbulbCreated with Sketch.