On 05/20/2018 06:41 AM, Arta S wrote:
Hello,
Thanks for your reply.
I am an advanced user, a client requested to install postgresql for
them. The postgresql was down in System> Status. I managed to start that
and now its running fine.
Now I have an odd problem. When I try to create a new account in WHM
(Account Creation) I get the message: *account creation status failed
the postgresql service is down*
See here:
https://forums.cpanel.net/threads/case-133489-create-a-new-account-account-creation-status-failed-the-postgresql-service-is-down.436381/
which makes reference to:
/usr/local/cpanel/logs/error_log
In the above case it was a missing entry in pg_hba.conf.
Have you looked in the error log?
2) If WHM is the above have you contacted cPanel for assistance?
*cPanel does not officially support postgresql.*
Their docs say different. From the Install link below:
"
Install or Update PostgreSQL on Your cPanel Server
Skip to end of metadata
Created by Documentation, last modified on Apr 19, 2018
Go to start of metadata
...
Important:
We only support versions of PostgreSQL that you install with the
/usr/local/cpanel/scripts/installpostgres script. We do not support
versions of PostgreSQL that you install via any other method.
Note:
cPanel & WHM functions with the version of PostgreSQL that ships with
your operating system.
"
4) Did you do the below to install Postgres?:
https://documentation.cpanel.net/display/CKB/Install+or+Update+PostgreSQL+on+Your+cPanel+Server
*Yes, I used this doc.*
Thank you
5) Are there logs for WHM and do they show anything relevant to this
problem?
On May 20, 2018, at 5:19 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
On 05/19/2018 01:13 PM, Arta S wrote:
please check the below message.
Thank you
Begin forwarded message:
*From: *Arta S <seyzed@xxxxxxxxx <mailto:seyzed@xxxxxxxxx>
<mailto:seyzed@xxxxxxxxx>>
*Subject: **postgresql is down in whm status page*
*Date: *May 19, 2018 at 5:16:31 PM GMT+4
*To: *webmaster@xxxxxxxxxxxxxx <mailto:webmaster@xxxxxxxxxxxxxx>
<mailto:webmaster@xxxxxxxxxxxxxx>
Hello team,
I have installed postgresql
Based on the documentation, now in WHM>Status it shows that
postgresql is down as well when I want to create a new account in
WHM it says account creation failed because postgresql is down.
Do you have any insight on that?
I dug the internet, but found nothing that I can relate to this issue.
I would appreciate if you could help me out.
You are going to need to provide more information:
1) Is WHM this-https://en.wikipedia.org/wiki/CPanel#WHM_(WebHost_Manager)?
2) If WHM is the above have you contacted cPanel for assistance?
3) Where did you get Postgres from and what version did you get?
4) Did you do the below to install Postgres?:
https://documentation.cpanel.net/display/CKB/Install+or+Update+PostgreSQL+on+Your+cPanel+Server
If not how did you install it?
5) Are there logs for WHM and do they show anything relevant to this
problem?
Thank you
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
