Search Postgresql Archives

Re: postgresql is down in whm status page

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux