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.

PostGRE Admin?

Discussion in 'Database Discussions' started by adriandaz, May 19, 2004.

  1. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    Hi, PostGRE installed successfully on my Fedora Box, cPanel 9.20 R5. But I don't know the admin username for PostGRE, or where to set it?

    anyone please let me know,

    Adrian.
     
  2. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    This is set in the WHM. It should be "Postgres Config" in the left frame.
     
  3. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    It only lets you set the password :confused:
     
  4. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    The admin user should be postgres on Linux. FreeBSD's is pgsql.
     
  5. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    so I should be able to log into the pgSQL administator (like phpMyAdmin) and see the databases etc...?
     
  6. AlphaWebspace

    AlphaWebspace Well-Known Member

    Joined:
    May 1, 2004
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kindom
    i think you should be able to.
     
  7. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    doesn't work :(
     
  8. AlphaWebspace

    AlphaWebspace Well-Known Member

    Joined:
    May 1, 2004
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    United Kindom
    hmm strange i tested it out earlier and mine doesnt work either
     
  9. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    hehe, well either pgSQL doesn't work like MySQL (I thought it did) or there is a bug.

    cPanel please investigate :)
     
  10. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    I must not really understand what you've been asking. First I thought you wanted to change your PostgreSQL admin password, then I thought you wanted the name of the admin user. Now you say that you want to use phpPgAdmin to adminster your databases?

    So is that the problem? Your username and password are not working for the phpPgAdmin login? The username and password to login to phpPgAdmin should be the same as the ones used to login to cPanel. If this is not working, then PostgreSQL is not configured properly. You will need to submit a support ticket to your web hosting company or if this is your server, then to cPanel support.
     
  11. adriandaz

    adriandaz Member

    Joined:
    May 19, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Hull, UK
    I am the server admin, and where do I make a ticket? :)
     
  12. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page