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.

erro: pg_connect()

Discussion in 'cPanel Developers' started by SanderNight, Mar 31, 2004.

  1. SanderNight

    SanderNight Member

    Joined:
    Nov 27, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hello People,
    please, I would like help about this...

    Fatal error: Call to undefined function: pg_connect() in

    thanks for all:confused:
     
  2. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    Recompile php with postgres support.

    Your trying to connect to a postgresql database and your php setup is currentlyi not configured to work with postgresql. TO do this cick the Upgrade Apache link in WHM and then check the postgres box.
     
  3. SanderNight

    SanderNight Member

    Joined:
    Nov 27, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Thanks fishfreek

    tryed, But I donĀ“t know make this

    I tryed too ./easyapache with option 4 but anything, without sucess

    please, help me :)
     
  4. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    create a php file named phpinfo.php with the following in it.

    <?php
    phpinfo();
    ?>

    Then call that file from the browser. Look at the build time on the top part of the page. See if its from when you just ran the upgrade apache or if its an older time/date.

    if its older then for some reason php didnt build properly. I ran into this problem myself and had to upgrade to 4.3.4 vs 4.3.3 You can do this via the upgrade apache function.

    If the build date is new then look in the configure line for -with=/pgsql

    If you see that or something simular. I probably have the format wrong then php is compiled with postgreql support.

    From that point make sure postgreql is running and is setup right. There is a fiarly exensive thread on a How To for postgresql here on these forums.

    Dont fret your not alone. Seems like the postgresql intergration is a bit shaky.
     
  5. Rafaelfpviana

    Rafaelfpviana Well-Known Member

    Joined:
    Mar 12, 2004
    Messages:
    142
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brazil
    Thanks a lot. This was exactly what we (me and SanderNight) needed.
    I have just another question.
    I read a post that you created for this same issue. At the end you mention a problem with the password. What was that problem and how did you fix it?
     
  6. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    The only thing I can recall is in WHM at the top clicking the postgresql configure link and assigning a root password and then clicking the config button next to that.

    As far as WHM is concerend thats about the only web based things you can do to postgesql. Well aside from restarting it at the bottom.
     
  7. Rafaelfpviana

    Rafaelfpviana Well-Known Member

    Joined:
    Mar 12, 2004
    Messages:
    142
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brazil
    Ok. did that already. I hope nothing else happens.
    Thaks a lot for everything. :) :) :) :) :)
     
  8. SanderNight

    SanderNight Member

    Joined:
    Nov 27, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Thank You Very much

    Thanks for all ;)
     
Loading...

Share This Page