PostgreSQL is not running after restart

Created:

2017-04-11 14:22:14 UTC

Modified:

2017-08-08 15:48:31 UTC

0

Was this article helpful?


Have more questions?

Submit a request

PostgreSQL is not running after restart

Applicable to:

  • Plesk Onyx for Linux

Symptoms

After installing PostgreSQL server, it is up and running. But when it is started in any way (control panel, or CLI), no errors occur and systemctl shows active status but server itself is not running.

Cause

Bug in /usr/bin/pg_ctlcluster utility that is responsible for the service restart. It doesn't handle non-english messages in PostgreSQL log.

Resolution

Please apply either of the following options:

  • Allow postgres user to connect to local database by adding ' local samegroup postgres ident' in /etc/postgresql/9.4/main/pg_hba.conf , before lines added by Plesk
  • Reinitialize database with English locale
Have more questions? Submit a request
Please sign in to leave a comment.