Thread: Fwd: postgresql is down in whm status page
please check the below message.
Thank you
Begin forwarded message:From: Arta S <seyzed@gmail.com>Subject: postgresql is down in whm status pageDate: May 19, 2018 at 5:16:31 PM GMT+4Hello 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
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
Hello,
2) If WHM is the above have you contacted cPanel for assistance?
4) Did you do the below to install Postgres?: https://documentation.cpanel.net/display/CKB/Install+or+Update+PostgreSQL+on+Your+cPanel+Server
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.
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?
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 youBegin 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
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