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!

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

A great help, many thanks. The documentation at: https://www.a2hosting.ca/kb/developer-corner/postgresql/remote-postgresql-connections proved useful.

Unfortunately it’s not available on a shared host. You need a VPS if you want to access the SSH and to run it. Check it out: heliohost.org/vps

Thanks, I think I am missing something.     My goal is to port a postgresql database from my local server to tommy.    I understood that remote access would allow me to do this.  Is there no way to port this database without the "upgrade" to VPS?

Are you talking about if there is a documentation to enable remote access yourself without you having to request Krydos? If so, users don't have permission to do this on a shared host. It always has to be done manually by Krydos and he does this to other users a lot of times.

 

I don’t know about the VPS server but I think you could probably do that on your own because you will have a full root admin access and pretty much you can do anything.

Thanks for the reply.  No, not looking to enable remote access myself.  Is access through ssh?  If that is the case, just the address/port to use to ssh in would be great. 

Remote access enabled.

Hi folks, I searched the wiki for remote access documentation but came up empty.  Any pointers? 

Hi folks, I have created a postgresql database:

nltrade_hockey1

with user:

nltrade_rh

I would like to request remote access to interact with the database.  

(feel free to delete if posted in incorrectly in duplicate!)

Best,

RH

Create the database and user, then post the name of each here. Krydos has to set remote access up manually.

Hi folks, the database name and user are:

nltrade_hockey1

nltrade_rh

Will post in a separate thread to ensure it is seen, feel free to delete one or the other. 

Hi folks, thought I would put forward my idea here and get feedback on the suitability of the platform. 

I am a university professor (mathematician) by profession.  I have been a hockey collector / small time dealer for many years.  

I developed a simple php/postgresql solution that allows other collectors search my available inventory and make purchase or trade offers.  I have had the website "public" several years ago.  4 or 5 years ago the rules on the server I was using changed and I could no longer have an outward facing presence.  

This is not meant to be a full fledged e-commerce site.  Right now people would send me an email with a list of items they would like and payment or a trade would be arranged.    Traffic would never be high, maybe a 0-10 visits per day.  

Is this platform suitable? 

What "primitive" e-commerce features are allowed? (For example a "shopping cart" which allows users to add items to a list which would then be emalied to me would likely be sufficient).  

Other things I should be aware of?

Best,

RH

Done. You're on Tommy now. Thank you for the donation. The domains should start working in the next hour or so.

 

If you see a 404 error, please flush your DNS and clear your cache.

Hi folks, great experience so far on the forums, will be happy to donate regularly once I see I can get it up and running (and the idea got legs!!). 

You can import the structure and data into an empty database using phppgadmin, or if you request remote access, could do it using anything on your computer that can connect to postgres.

Thanks!  I assume I can request remote access from the control panel? 

Hi folks, thanks for all your help so far.  I have a postgresql database on a local server that I would like to move to heliohost.  Can I "restore" a database (setup and data) on the heliohost server? (soon to be tommy). 

Best,

R Haynes

Hi folks, I have made a small donation via paypal transaction number: 08J40312NX537360G, user id: nltrade.  I would like to be moved to tommy please.

RH

Hi folks, based on my list of needs the system suggested tommy but had no slots available yesterday when I first signed up.  It told me to wait for 8 hrs, which I did.  The message seemed to suggest that I would get a slot then but no dice unfortunately.    What is the easiest way to move things to tommy? 

If you have contents in your .HTML file inside of your public_html folder, then you can simply view it as yourdomain.heliohost.us/yourfile.html into the search bar address.

 

If you want, you can also use a “Redirects” feature inside cPanel underneath Domains to point to your html file so that way your users will able to view your contents page instead taking them to the /index page and letting touch your files which you don’t want that!

Thanks - will the same work for a .php file? 

Hi folks, newbie here, the main page for my website is something other than index.html, how do I tell the server the name of this file?