Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 3459 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

PostgreSQL korrupt after ACC crash

firebear_01
Hi all,
two times after a crash of a VirtualBox machine within ACC 2.202 the PostgreSQL Database is corrupted and the ACC is non functional.
Only a new installation with a Backup brings it back to life.

Is there a possibility to rebuild the Database within the ASG ?

Thanks for an aswer
Firebear


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

    Hi firebear,


    Is there a possibility to rebuild the Database within the ASG ?



    What exactly do you mean by this?

    Do you like to repair the ACC database such that you don't need to reinstall the ACC? If so, do the following steps:


    • login to the ACC per ssh as root
    • stop the accd by calling  
      /var/mdw/scripts/accd stop
    • rebuild the database by calling  
      /etc/init.d/postgresql rebuild

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

    • start the accd by calling  
      /var/mdw/scripts/accd start
    • ACC should now be fully functional, so you can restore the backup



    Regards, Hakan

  • 0 in reply to Hakan Yueksel
    Sorry, I have to correct myself concerning what I wrote here:

    rebuild the database by calling 
    /etc/init.d/postgresql rebuild



    This convenient rebuild call is not available in ACC V2.202 but will be available with AC V3.

    So with ACC V2.202 it is needed to do this step manually: 


    /etc/init.d/postgresql stop

    rm -rf /var/storage/pgsql/data/*

    rm -rf /var/log/reporting/pgsql/*

    /etc/init.d/postgresql start


    Regards, Hakan
  • 0 in reply to Hakan Yueksel
    Hi Hakan,

    thanks a lot for your detailed answer.

    Greets
    Firebear
Reply Children
No Data
Unfiltered HTML