Cannot connect to PostgreSQL database through PHP

Asked by:
HubFans / n/a Points Time:
2016-06-16 5:07 am EST Category:
Databases Hits:
289

I've created a PostgreSQL database and user in my Cpanel. In PHP I am trying to connect to that database using pg_pconnect(), and getting the following error message:

Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "[local]", user "{username},", database "databasename,", SSL off

I've tried specifying the host as localhost, and as my domain's hostname, neither of which have worked either.

ANSWERS

johnpaulb-whh2

Staff

12,339 Points

2016-06-16 8:39 pm EST

Hello,

Thank you for your question regarding issues connecting to a PostgreSQL database via PHP. We are happy to help you troubleshoot further but will need some additional information.

Can you provide the full code syntax you are using?

Please provide a link to the script.

Include any additional information to help us replicate and troubleshoot this issue.

Thank you,
John-Paul

This is the PHP I'm trying to execute:

$conn = pg_pconnect("dbname={dbname}, user={username}, password={password}, port=5432, host=localhost");

The username, password, database name are all definitely correct.