Guest User!

You are not Sophos Staff.

Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 7 replies
  • Subscribers 2 subscribers
  • Views 8900 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

Disk Data is full

Goldy_01
Hi.

Can any one tel me if the commands below applied to Ver 9 too?

Rebuild the database with following commands - line by line:

/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres: postgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v


Thanks...
[:)]


This thread was automatically locked due to age.
  • 0
    /etc/init.d/postgresql rebuild

     is the new method to clear postgresql data.

    EDIT 2016-07-12 BAlfson: In newer versions, the command is /etc/init.d/postgresql92 rebuild

  • 0 in reply to Scott_Klassen
    Thanks.

    I'll try it.
    It seems something is wrong.
    My Data disk filed up to 90%, and the CPU seems like crazy.
  • 0
    Two things you can do before digging deeper.

    1)  Go to the advanced tab in the web proxy and clear the cache.  If there's a lot in there, it can take a few minutes to clear, during which time I/O will go a little nuts.
    2)  Reboot to clear temp files.
  • 0 in reply to Scott_Klassen
    Do things you can do before digging deeper.

    1)  Go to the advanced tab in the web proxy and clear the cache.  If there's a lot in there, it can take a few minutes to clear, during which time I/O will go a little nuts.
    2)  Reboot to clear temp files.


    1. I don't use cache.
    2. already tried it - no salvation.

    I use the command: cd /var/storage/cores  ->  ls
     then rm * to remove them all.
    That put my data disk back to normal size.

    I also run your suggestion, and it seems to help.
    The CPU and the memory graph also look normal now.
    I wonder what can cause this malfunction.

    Thanks [:)]
  • 0 in reply to Goldy_01
    Sees the difference...

    Astaro.jpg
  • 0
    OK.
    So far - not so good.
    1. Two - three times a day I'm getting "Snort not running - restarted"
    2. About once a day - "Http proxy not running - restarted"
    3. Every 4 days I have to run the command: cd /var/storage/cores -> ls , then rm * to Clean up the Disk data.
    4. Periodically every day, the CPU acts like crazy - jumping up and down.
    5. I have opened a case in Astaro a week ago.
    So far haven't heard from them…
    ):
  • 0
    Goldy, Are you saying the rebuild of the PostgreSQL databases didn't help?

    Cheers - Bob