Re: postgresql is down in whm status page - Mailing list pgsql-general

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com