Hello all.
I had some errors in system log. Errors like this:
FATAL: database "reporting" does not exist
So I followed this instruction to rebuild my database:
(https://support.astaro.com/support/index.php/Advanced_Database_Troubleshooting)
Stop postgres (this makes sure selfmon does not interfere with your actions), clean out the data directorys and start postgres again.
asg120:/root # /etc/init.d/postgresql stop
:: Stopping PostgreSQL done
asg120:/root # rm -rf /var/storage/pgsql/data /var/log/reporting/pgsql/*
asg120:/root # /etc/init.d/postgresql start
:: Initializing the PostgreSQL database done
:: Starting PostgreSQL done
asg120:/root # /var/mdw/scripts/smtp restart
:: Restarting SMTP Proxy
:: Stopping SMTP Proxy
[ ok ]
:: Starting SMTP Proxy
[ ok ]
[ ok ]
And then I tried to check if my database is working correctly following instructions on the same page from topic "Historical Data for Top Blocked Usage is Lost". When entering command
"\d websec_bud_data"
I see following:
"FROM websec_bud a, webanon_clients b, webanon_users c"
It is wrong result, and I tried to fix this. But when I'm applying long listing, which is written down there (table creation listing I mean), it returns following error:
ERROR: column a.dayabs does not exist
LINE 3: a.dayabs as dayabs,
Maybe this line - "FROM websec_bud a, webanon_clients b, webanon_users c" - is ok for version 8? But I can't see any network usage statistics not for today. Maybe it was lost and now everything will be ok, or something is wrong?
Thank you.
This thread was automatically locked due to age.