How can I connect to a postgres database in WebMatrix php?

Question

I'm not exactly sure, how I can connect to a database I have on heroku through my local server created by WebMatrix. I have code to connect to the database work if I run the php script when my application is hosted on heroku. The line below fails:

$dbconn = pg_connect("host=someEC2Instance.com port=5432 dbname=xxxxxxx user=xxxxxxxx password=xxxxxxxxxx sslmode=require options='--client_encoding=UTF8'") or die('Could not connect: ' . pg_last_error());

I want to work with the database hosted on heroku, does anybody know what's wrong here?

Ralph D. · Accepted Answer · 2013-12-17 11:44:57Z

1

Normaly databases are not configured for "external" access. I dont know the hoster heroku very well but: I would say you can't access the database "from external" with your webserver.

Could you post the complete error message?

You could echo the "pg_last_error".. I bet it says something like "connection refused" or "connection timed out".

To access the database you should host the WebApplication on heroku OR install the database local on your pc.

Greetings.

answered Dec 17, 2013 at 11:44

Ralph D.

312 bronze badges

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

2 Comments

John Beynon Over a year ago

not the case with Heroku - they allow direct database connections.

Matan Vardi Over a year ago

No line after pg_connect execute, so I can't output pg_last_error

Collectives™ on Stack Overflow

How can I connect to a postgres database in WebMatrix php?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related