HelioHost Posted July 2, 2017 Posted July 2, 2017 Dear Heliohost, I developed a site for a client on Postgres 9 with LTREE extension and PHP, it uses email for login confirmation. That's what I need to test and then tell the client what his hosting fee will be... but I have to show him it working. I went ahead an logged in anyway, don't know why it doesn't give me Postgres, I did tick it. User name is.... bobspar... stopped at waiting to create your account. I used email bobspar@gmail.com If you can help me show the product to my client, great thanks If he likes it a maintenance contract would come... along with certificates, domain names and all the rest... it's a start up idea.Bob Spar ---This email has been checked for viruses by Avast antivirus software.https://www.avast.com/antivirus
Krydos Posted July 3, 2017 Posted July 3, 2017 You can create a postgresql database by going to https://johnny.heliohost.org:2083/frontend/paper_lantern/psql/index.html
HelioHost Posted July 3, 2017 Author Posted July 3, 2017 Thanks for the quick reply... I found postgres 8.4 and I'm trying it, I actually developed on 9 but I haveused straight forward stuff so it should go back to 8.4... I do have one little problem... I cant install the LTREE extension on theserver... PERMISSION DENIED because the old 8.4 uses the C language. LTREE is a standard extension that lets one work with trees, and I have usedit but cant get it in. On 8.4 these extensions come in the contribution pack... I attach the actualsql that needs to be run... it comes from postgres themelves. My user name is BobSpar@gmail.comThe DB is BobSpar_DIY with a GOS schema. Please could an admin rights person enable this LTREE extension on my DB? On postgres 9 the command is CREATE EXTENSION ltree SCHEMA pg_catalogeasy stuff... but on 8.4 its a huge script.... Note where they put it on 9 in the PG_CATALOG... not the actual scheme thatneeds it... this is because then all schemas see it..I'm not sure if that is the same on 8.4... perhaps it has to be put in allschemas that need it there... my schema is GOS and that is how the script issetup attached... Thanks... -----Original Message-----
Krydos Posted July 3, 2017 Posted July 3, 2017 Tommy has postgresql 9.2.18 Johnny has postgresql 8.4.20 Perhaps you should move your account to Tommy?
HelioHost Posted July 3, 2017 Author Posted July 3, 2017 OK it says I must delete this account and wait 48 hours...I'll try this way... -----Original Message----- It says Tommy is FULL... so that didn't work...I had to delete the old account... snookered ha haI think LTREE on postgres 8.4 would do it...But yes I think Tommy might be better... Happy to pay a donation after I see the site online, but not before, also my client will do bank transfers, he is tired of credit cards being blocked as soon as used on the web.The banks have become paranoid, and block as soon they see a transaction in another country, credit cards are near useless nowadays.PayPal might be better... I'm the geek trying to show the client a job and get him a hosting provider... this is my problem. Anyway thanks.... -----Original Message-----
Krydos Posted July 3, 2017 Posted July 3, 2017 Free Tommy signups reset at midnight UTC and can sometimes fill quickly. The night before last Tommy signups were open for over two hours, and I've seen them fill in six seconds before. Just be there at midnight mashing the refresh button and you should get an account. We provide the thank you gift of an instant Tommy invitation, thereby avoiding the annoyance of trying to get a Tommy account for free, to our donors. It makes sense that you wouldn't want to donate until after you see the server performance though, but I can assure you that we haven't had a single complaint about Tommy so far.
Recommended Posts