Connect to PostgreSQL in Cpanel with php

Question

I'm new in this cpanel and I want to ask how to connect to Postgres in cpanel using php?

I use this simple code

<?php

$dbconn = pg_connect("host=localhost port=5432 dbname=test user=domain_test password=test")
or die('connection failed: ' . pg_last_error());

?>

and It keep on returning connection failed on my browser, can somebody tell me how to do it correctly?

And what's the error? (see how to get it here - php.net/manual/en/pgsql.examples-basic.php) — Milen A. Radev
– Milen A. Radev, Commented Jan 23, 2014 at 11:48
the . pg_last_error() contains nothing... its empty.. sorry.. i will include it right away... — Diom
– Diom, Commented Jan 23, 2014 at 11:51
i have checked the php logs, and did not find anything... regarding to postgres log, i didn't find the file in my cpanel... — Diom
– Diom, Commented Jan 23, 2014 at 12:10
@Diom Look on the file system - it's usually in /var/lib/postgresql or /var/lib/pgsql, but if you're on the kind of hosting system that has CPanel, anything goes... — Craig Ringer
– Craig Ringer, Commented Jan 23, 2014 at 12:21

tlenss · Accepted Answer · 2014-01-23 12:22:39Z

1

You can't really catch connection errors with pg_last_error. You will need to use pg_connection_status for that. But it will not give you enough info to take care of the connection issue.

It looks like error reporting is disabled in your case. So give this a try

error_reporting(E_ALL);
ini_set('display_errors', true);

$dbconn = pg_connect("host=localhost port=5432 dbname=test user=domain_test password=test");

$stat = pg_connection_status($dbconn);
if ($stat === PGSQL_CONNECTION_OK) {
    echo 'Connection status ok';
} else {
    echo 'Connection status bad';
}

answered Jan 23, 2014 at 12:22

tlenss

2,6172 gold badges23 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Diom Over a year ago

Alright I got it, I just need to change the host to host=127.0.0.1

Collectives™ on Stack Overflow

Connect to PostgreSQL in Cpanel with php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related