Astaro PostgreSQL Fix

For some months now my Astaro firewall was unable to start the PostgreSQL service on boot. Since this didn’t seem to have any real impact on function or performance, I started some feeble attempts at fixing it but never succeeded until today.

{openx:6}

The solution is quite easy: After logging in as root on the Astaro’s console, you just have to move all the databases and the reposting logs out of the way:

Afterwards, just start the PostgreSQL service manually:

I also noticed that running without PostgreSQL actually did have some (minor) impact. After restarting the service I got delivered some mails that had hung in the queue since January 6. Will have to flush all the queues to make sure everything is clean again, I guess.

Incoming search terms:

• postgres astaro
• astaro postgres log
• astaro starting postgresql
• astaro postgresql startet nicht
• astaro postgresql failed
• astaro postgresql
• whocares de/astarto-postgresql
• psql -u postgres reporting
• pgsql flush
• whocares de/astaro-postresql-fix