Thread Info
  • State Not Answered
  • Replies 19 replies
  • Subscribers 0 subscribers
  • Views 10305 views
  • Users 0 members are here
Options
Suggested

[9.060][CLOSED] Data partition filling up

Billybob
Hi it seems that my storage partition is filling up pretty fast. The culprit seems to be the /var/storage/pgsql92/data/pg_xlog directory. I have very light load so such a large log directory seems out of the ordinary.
gatekeeper:/var/storage/pgsql92/data/pg_xlog # du -ch
12K     ./archive_status
2.6G    .
2.6G    total



The screenshots of my partition usage are attached below

Regards
Bill
Parents Reply Children
  • 0 in reply to Monarch
    Yes I started getting errors like
    2013:02:04-10:21:18 gatekeeper httpproxy[32097]: id="0003" severity="info" sys="SecureWeb" sub="http" request="0xa463db0" function="read_response_body_file_chunked" file="response.c" line="1172" message="failed to move tempfile /tmp/tmp_1XCIRA from ram disk to hard disk: No space left on device"

    and my hardware usage 
    gatekeeper:/var/log # df -h

    Filesystem      Size  Used Avail Use% Mounted on

    /dev/sda6       5.3G  1.9G  3.2G  37% /

    udev           1014M   76K 1014M   1% /dev

    tmpfs          1014M     0 1014M   0% /dev/shm

    /dev/sda1       339M   21M  302M   7% /boot

    /dev/sda5       4.7G  4.7G     0 100% /var/storage

    /dev/sda7       6.2G  240M  5.6G   5% /var/log

    /dev/sda8       713M   28M  649M   5% /tmp

    tmpfs          1014M   52K 1014M   1% /var/storage/chroot-smtp/tmp/ram

    tmpfs          1014M  4.9M 1009M   1% /var/storage/chroot-http/tmp

    I will delete a few files and then do what Bastian did earlier.

    Regards
    Bill

    Edit: Deleted my pg_xlog [:P] 
    gatekeeper:/var/storage/pgsql92/data/pg_xlog # df -h

    Filesystem      Size  Used Avail Use% Mounted on

    /dev/sda6       5.3G  1.9G  3.2G  37% /

    udev           1014M   76K 1014M   1% /dev

    tmpfs          1014M     0 1014M   0% /dev/shm

    /dev/sda1       339M   21M  302M   7% /boot

    /dev/sda5       4.7G  895M  3.6G  20% /var/storage

    /dev/sda7       6.2G  240M  5.6G   5% /var/log

    /dev/sda8       713M   28M  649M   5% /tmp

    tmpfs          1014M   52K 1014M   1% /var/storage/chroot-smtp/tmp/ram

    tmpfs          1014M  4.9M 1009M   1% /var/storage/chroot-http/tmp