Thread: Fwd: postgresql is down in whm status page

Fwd: postgresql is down in whm status page

From
Arta S
Date:
please check the below message. 

Thank you

Begin forwarded message:

From: Arta S <seyzed@gmail.com>
Subject: postgresql is down in whm status page
Date: May 19, 2018 at 5:16:31 PM GMT+4

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.

Thank you


Re: Fwd: postgresql is down in whm status page

From
Adrian Klaver
Date:
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>>
>> *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>
>>
>> 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


Re: postgresql is down in whm status page

From
Arta S
Date:
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

2) If WHM is the above have you contacted cPanel for assistance?
cPanel does not officially support postgresql.
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> 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>>
*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>

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

Re: postgresql is down in whm status page

From
Adrian Klaver
Date:
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