PostgreSQL database

[aztech]

Hi everybody, I wrote this php script for connect to db:

 

<?php
$connessione=pg_connect("host=heliohost.org port=5432 dbname=aztech_prova user=aztech_fuma password=**********") or die("Database non disponibile");
?>

 

But it doesn't work, I receive this error:

 

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "65.19.143.2", user "aztech_fuma", database "aztech_prova", SSL off in /home1/aztech/public_html/registrazione.php on line 2
Database non disponibile

 

Could you explain me the problem?

 

Thank you

[jje]

Although I have no experience of PostgreSQL, try replacing

host=heliohost.org

with

host=stevie.heliohost.org

[Guest Geoff]

Are you developing on your local computer, or heliohost?

 

If you are connecting from your local computer, the connection might not work.

[aztech]

Although I have no experience of PostgreSQL, try replacing

host=heliohost.org

with

host=stevie.heliohost.org

 

I already tried you're method but it still doesn't work.

 

 

Are you developing on your local computer, or heliohost?

 

If you are connecting from your local computer, the connection might not work.

 

I tried to work online, it's the same.

 

[jje]

Try...

 

<?php
$connessione=pg_connect("host=localhost dbname=aztech_prova user=aztech_fuma password=**********") or die("Database non disponibile");
?>

 

Sorry - I have no experience with PostgreSQL but I'll do the best I can.

 

note: that code will only work if the script is on your heliohost website, not remotely

[aztech]

Try...

 

<?php
$connessione=pg_connect("host=localhost dbname=aztech_prova user=aztech_fuma password=**********") or die("Database non disponibile");
?>

 

Sorry - I have no experience with PostgreSQL but I'll do the best I can.

 

note: that code will only work if the script is on your heliohost website, not remotely

 

 

Thank you very very much!!! Now it works!!!!

 

[jje]

Your welcome! We got there in the end!!