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

/var/storage full pgsql is using 4.5 G

inle
Hi all
Well, my /var/storage is full % pgsql is using 4.5 G bytes, wath can I do??

Thanks


This thread was automatically locked due to age.
Parents
  • 0
    Hi 

    IF I execute the command /var/storage/pgsql/init/reporting_db_init.sh will it solve my problem???

    Thanks
  • 0 in reply to inle
    Hi you all.

    I found in a thread from the year 2007  the follawing command de sequence:

    # sudo su

    # /etc/init.d/ulog stop
    # /etc/init.d/syslogng stop

    # cd /var/log/reporting/pgsql/ 
    # mv 16*** /home


    # su - postgres

    > /var/storage/pgsql/init/reporting_db_init.sh

    # su root
    # /etc/init.d/syslogng start
    # /etc/init.d/ulog start

    # test -x /usr/local/bin/snort-cleanup && /usr/local/bin/snort-cleanup
    # /usr/local/bin/report_render.plx --sendmail

    # reboot
    killall ctasd

    Thanks
  • 0 in reply to inle
    If you just want to reduce the size that the database is taking on the disk, you could also use Reporting::Settings to configure shorter keep times. Shorter keep times -> less data that has to be stored. Using the above will wipe the complete database.

    Cheers,
     andreas
Reply
  • 0 in reply to inle
    If you just want to reduce the size that the database is taking on the disk, you could also use Reporting::Settings to configure shorter keep times. Shorter keep times -> less data that has to be stored. Using the above will wipe the complete database.

    Cheers,
     andreas
Children