porting postgresql and connection issue

[nltrade]

Hi folks, so I am making *some* progress porting my postgresql database to heliohost.  

 

The import process complains about some settings - my local postgresql server is running version 13.2 while heliohost is running 9.2 or 9.3.    As far as I can tell it did not inhibit the importation process ... 

 

Now I am trying to connect to the database via:

 

$connection = pg_connect("dbname=nltrade_hockey1 user=nltrade_rh host=https://nltradingcards.heliohost.us/");

 

in my php file.    This all works locally and here I have changed the dbname, user, and host.  The message complains:

 

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "https://nltradingcards.heliohost.us/" to address:

 

 

What am I missing? 

 

Best,

R Haynes

[nltrade]

Hi folks, so I am making *some* progress porting my postgresql database to heliohost.  

 

The import process complains about some settings - my local postgresql server is running version 13.2 while heliohost is running 9.2 or 9.3.    As far as I can tell it did not inhibit the importation process ... 

 

Now I am trying to connect to the database via:

 

$connection = pg_connect("dbname=nltrade_hockey1 user=nltrade_rh host=https://nltradingcards.heliohost.us/");

 

in my php file.    This all works locally and here I have changed the dbname, user, and host.  The message complains:

 

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "https://nltradingcards.heliohost.us/" to address:

 

 

What am I missing? 

 

Best,

R Haynes

 

Hi folks, just an update - so the pg_connect command did not like the https:// in front of nltradingcards.heliohost.us, and then I needed to add the password.  So moving forward!  Thanks for all your previous assistance!

[wolstech]

That would make sense. HTTP refers to the protocol to be used, postgres does not speak HTTP.