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

I Did something Wrong?

Guys, 

Our ASG 425 is utilizing the CPU higher than before we upgrade to UTM 9, ive browse some thread and I end up with rebuilding the postgres database as mentioned here;

How to recreate a postgres database: Astaro Security Gateway


the thing is, the 1st command i entered has no error;

/etc/init.d/postgresql rebuild

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


but when I entered the succeeding commands, especially the command after the rm stuff;

Drop and create only reporting db:

    Remove files in /var/log/reporting/pgsql/:
     
     rm -rf /var/log/reporting/pgsql/*
    /var/storage/pgsql/init/reporting_db_init.sh -v

I get some errors, and when I check the system logs, I got these series  of logs  the system messages;

2012:12:20-15:20:51 astaro ulogd[4644]: pg1: connect: could not connect to server: No such file or directory
2012:12:20-15:20:56 astaro ulogd[4644]: pg1: connect: could not connect to server: No such file or directory
2012:12:20-15:21:00 astaro postgres[7724]: [1-1] LOG:  database system was shut down at 2012-12-20 15:20:59 AST
2012:12:20-15:21:00 astaro postgres[7725]: [1-1] FATAL:  the database system is starting up
2012:12:20-15:21:00 astaro postgres[7723]: [1-1] LOG:  database system is ready to accept connections
2012:12:20-15:21:00 astaro postgres[7728]: [1-1] LOG:  autovacuum launcher started
2012:12:20-15:21:00 astaro postgres[7767]: [2-1] ERROR:  database "epp" does not exist
2012:12:20-15:21:00 astaro postgres[7767]: [2-2] STATEMENT:  DROP DATABASE epp;
2012:12:20-15:21:00 astaro postgres[7767]: [2-3] 
2012:12:20-15:21:00 astaro postgres[7769]: [2-1] ERROR:  role "epp" does not exist
2012:12:20-15:21:00 astaro postgres[7769]: [2-2] STATEMENT:  DROP ROLE epp;
2012:12:20-15:21:00 astaro postgres[7769]: [2-3] 
2012:12:20-15:21:01 astaro postgres[7787]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:01 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:05 astaro postgres[7788]: [2-1] FATAL:  database "smtp" does not exist
2012:12:20-15:21:06 astaro postgres[7790]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:06 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:07 astaro postgres[7811]: [2-1] ERROR:  database "hotspot" does not exist
2012:12:20-15:21:07 astaro postgres[7811]: [2-2] STATEMENT:  DROP DATABASE hotspot;
2012:12:20-15:21:07 astaro postgres[7811]: [2-3] 
2012:12:20-15:21:11 astaro postgres[7817]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:11 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:15 astaro postgres[7842]: [2-1] FATAL:  database "smtp" does not exist
2012:12:20-15:21:16 astaro postgres[7844]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:16 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:21 astaro postgres[7850]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:21 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:22 astaro postgres[7891]: [2-1] ERROR:  database "reporting" does not exist
2012:12:20-15:21:22 astaro postgres[7891]: [2-2] STATEMENT:  DROP DATABASE reporting;
2012:12:20-15:21:22 astaro postgres[7891]: [2-3] 
2012:12:20-15:21:22 astaro postgres[7893]: [2-1] ERROR:  tablespace "reporting" does not exist
2012:12:20-15:21:22 astaro postgres[7893]: [2-2] STATEMENT:  DROP TABLESPACE reporting;
2012:12:20-15:21:22 astaro postgres[7895]: [2-1] ERROR:  role "reporting" does not exist
2012:12:20-15:21:22 astaro postgres[7895]: [2-2] STATEMENT:  DROP ROLE reporting;
2012:12:20-15:21:22 astaro postgres[7895]: [2-3] 
2012:12:20-15:21:25 astaro postgres[7902]: [2-1] FATAL:  database "smtp" does not exist
2012:12:20-15:21:26 astaro postgres[7906]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:26 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist
2012:12:20-15:21:31 astaro postgres[7921]: [2-1] FATAL:  database "reporting" does not exist
2012:12:20-15:21:31 astaro ulogd[4644]: pg1: connect: FATAL:  database "reporting" does not exist




I do something stupid? since the knowledge base is for the software version, too late to notice..tsk tsk tsk..can anyone help me to bring back the POSTGRES stuff the way it is working before, im afraid it will lead these for a bigger problem?..



This thread was automatically locked due to age.
Parents Reply Children
No Data