Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 14 replies
  • Subscribers 4 subscribers
  • Views 34905 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Got mail that says data disk is filled up to 75%

ErikFranzen
My data disk partition size is 4.5GB
Tomorrow I got an mail saying the data disk is full

Connected via SSH and found out that the file

/var/storage/pgsql92/pg_xlog was 1,8GB big

Ran the following command as root,

/etc/init.d/postgresql92 rebuild


which solved the problem. Now the data disk is filled up to 17%

However, my question is if I have to do this repeatedly?

Firmware version 9.105-9


This thread was automatically locked due to age.
Parents
  • 0
    /etc/init.d/postgresql92 rebuild should still work, but I would suggest a different approach.

    cd /var/storage/pgsql92/data/pg_xlog
    ls


    The last few files in the  list are necessary, but you can delete the older ones without the data loss created by the rebuild command. to get rid of the 16 files that begin 00000001000000080000007 and the 16 that start with 00000001000000080000008, do

    rm 00000001000000080000007?
    rm 00000001000000080000008?


    I wouldn't do that on a system with a paid license.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • 0
    /etc/init.d/postgresql92 rebuild should still work, but I would suggest a different approach.

    cd /var/storage/pgsql92/data/pg_xlog
    ls


    The last few files in the  list are necessary, but you can delete the older ones without the data loss created by the rebuild command. to get rid of the 16 files that begin 00000001000000080000007 and the 16 that start with 00000001000000080000008, do

    rm 00000001000000080000007?
    rm 00000001000000080000008?


    I wouldn't do that on a system with a paid license.

    Cheers - Bob
     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Children
  • 0 in reply to BAlfson
    make a test with a free license

    in this directory  have only 2 file 000000010000000000000001, 000000010000000000000002 and archive_status directory

    each file is 16mb, but have data disk 2,6g at 86%

    postgres rebuild say it, is right?

    myfirewall:/root # /etc/init.d/postgresql92 rebuild
    Rebuilding PostgreSQL database, all reporting data will be lost!
    Enter "yes" to continue...
    yes
    :: Stopping PostgreSQLcould not change directory to "/root"
                                                                         done
    :: Initializing the PostgreSQL databasecould not change directory to "/root"
                                                                         done
    :: Starting PostgreSQL                                               done
    :: Restarting SMTP Proxy
    :: Stopping SMTP Proxy
    [ ok ]
    :: Starting SMTP Proxy
    [ ok ]
    [ ok ]


    tnx
Unfiltered HTML