nltrade

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.

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?

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.

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

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

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!!).

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?

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?