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

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 Hakan Yueksel over 13 years ago
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
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 Hakan Yueksel over 13 years ago
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
Cancel
Vote Up 0 Vote Down

Cancel

Children

0 Hakan Yueksel over 13 years ago 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
Cancel
Vote Up 0 Vote Down

Cancel
0 firebear_01 over 13 years ago in reply to Hakan Yueksel

Hi Hakan,

thanks a lot for your detailed answer.

Greets
Firebear
Cancel
Vote Up 0 Vote Down

Cancel