daskunk

Oh and I tried with and without the Port=5432 ... same result either way.

Thanks

Reverted back to the first one and tried again.

$dbconn=pg_connect("host=localhost port=5432 dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=*****")

Still getting this error

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/psql.php on line 12

I tried both

$connessione=pg_connect("host=localhost dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=<removed>") or die("Database non disponibile");

which resulted in

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/psql.php on line 12

and

$connessione=pg_connect("host=localhost.heliohost.org dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=<removed>") or die("Database non disponibile");

which resulted in

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "localhost.heliohost.org" to address: Name or service not known in /home/daskunk/public_html/pbc/psql.php on line 12

So if neither is correct syntax, can someone please help with the correct syntax.  Otherwise is one of them is correct usage of localhost, then that is not working either.

I would really like to get my postgresql db working from my web site.

Thank you

I was trying to figure this out on my own by reading various posts and I'm not sure if the problem is on my side or not. I recently created a Postgresql database and now I'd like to access it through a PHP script from my heliohost web site.

The pg_connect call in my PHP script looks like
 
$result=pg_connect("host=ricky.heliohost.org port=5432 dbname=daskunk_DaSkunkWorksPBC user=daskunk_php password=*****");


I'm getting this response

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "64.62.211.134", user "daskunk_php", database "daskunk_DaSkunkWorksPBC", SSL off in /home/daskunk/public_html/pbc/

My info
Database:  daskunk_DaSkunkWorksPBC
User:      daskunk_php
Domain:    daskunk.heliohost.org
Server:    ricky

Any help in resolving this is greatly appreciated. Thank you in advance.