php - pgAdmin III can connect to Heroku Postgresql. PDO can't connect to same database. Why? -
i'm new here , apologize if i'm doing wrong post question.
my question quite simple: machine can connect pgadmin iii remote postgresql (provide heroku). can read/write database without problems.
unfortunately, from same machine, can't connect php page using pdo extension (it work perfectly). error give me is:
sqlstate[08006] [7] fatal: no pg_hba.conf entry host "x.x.x.x", user "username", database "mydatabase", ssl off
i should edit "pg_hba.conf" resolve, unfortunately can't edit on heroku (or maybe don't know how do).
i don't understand why pgadmin iii can connect php page can't.
thanks in advance.
you ans in following ans think user
have no entry in pg_hba.conf
file , pgadmin iii
, php
users different check link
Comments
Post a Comment