Re: postgresql is down in whm status page

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(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> 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(at)gmail(dot)com <mailto:seyzed(at)gmail(dot)com>
>>>> <mailto:seyzed(at)gmail(dot)com>>
>>>> *Subject: **postgresql is down in whm status page*
>>>> *Date: *May 19, 2018 at 5:16:31 PM GMT+4
>>>> *To: *webmaster(at)postgresql(dot)org <mailto:webmaster(at)postgresql(dot)org>
>>>> <mailto:webmaster(at)postgresql(dot)org>
>>>>
>>>> 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(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com