The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PostgreSQL problem...where is phppgadmin?

Discussion in 'General Discussion' started by Annibal, Jun 20, 2009.

  1. Annibal

    Annibal Registered

    Joined:
    Jun 20, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Good morning,
    I had installed PostgreSQL using /scripts/installpostgres and updated apache through EasyApache.

    In the "SQL Services" i got only the "Postgres Config" icon and nothing else :confused:.

    In "Service Manager" I have the postgresql's options (enable and monitor) both checked.
    In the "service monitor" postgresql results up and running.

    In /usr/local/cpanel/base/3rdparty there is the phpPgAdmin directory...but how to access it? how to create a database through the WHM interface? Why there is not the phppgadmin icon?

    Any suggestion is appreciated,
    thank you!

    Configuration:
    cPanel 11.24.4-R36167 - WHM 11.24.2 - X 3.9
    CENTOS 5.3 i686
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    In WHM you will need to set your root password for Postgres and go through Postgres Config in WHM.

    Don't forget to recompile PHP so that PostgreSQL can be used via PHP.
     
  3. Annibal

    Annibal Registered

    Joined:
    Jun 20, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hello and thank you for your reply but i'm not sure to understanding what you saying:

    "In WHM you will need to set your root password for Postgres"

    Does that means that in Main >> SQL Services >> Postgre config, in the field "Postgres Password" i have to write my SERVER root password???

    By enter in that field any password (no my server root password) I get this message "postmaster signaled ALTER ROLE postmaster signaled Password successfully changed".

    Then in that page I have only a button: "Install Postgres Config" that once pressed gives me: "Configuration successfully updated postmaster signaled"

    "Don't forget to recompile PHP so that PostgreSQL can be used via PHP. "
    I did it.

    My main question is: is normal that logged as root in WHM i don't have the phppgadmin icon? I have the phppgadmin icon only logged with a normal domain user account.

    I'm sorry i'm a newbie with cpanel i'm migrating from plesk.

    Thanks again
     
  4. fineline

    fineline Active Member

    Joined:
    Apr 10, 2006
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    I think what he means is when you log into your WHM
    Under SQL Services you will see "MySQL Root Password"
    There should also be a place to set the root password for Postgres also

    This might help you too.

    On your navigation pane on the left In the "Find" box
    type "post" this should help you see the Postgres links
    and eliminate most the others.

    Once you change your password for it then you will need to go through the

    "Postgres Config"

    After that then you will need to recompile PHP so that PostgreSQL can be used via PHP.
     
  5. Annibal

    Annibal Registered

    Joined:
    Jun 20, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    > Under SQL Services you will see "MySQL Root Password"
    > There should also be a place to set the root password for Postgres also

    Hello fineline and thank you.

    I have in Main >> SQL Services >> Postgres Config, a field called "Postgres Password" and that's it.

    > On your navigation pane on the left In the "Find" box
    > type "post" this should help you see the Postgres links
    > and eliminate most the others.

    Nice trick! however didn't find anything new and where is supposed to be the phppgadmin icon for the server administrator?

    Again, thanks!
     
Loading...

Share This Page