HelioHost Posted December 7, 2017 Posted December 7, 2017 Username: N/A, Server: N/A, Main Domain: N/A Hello, I'd like to know if one can install/use postgresql extensions liketablefunc and postgis in the heliohost postgresql database.Thanks in advance.
HelioHost Posted December 7, 2017 Author Posted December 7, 2017 Hello, I'm not registered yet. I'd like to know if I can install/use theextensions mentioned above with the heliohost postgresql db. Regards. On Thu, Dec 7, 2017 at 12:27 PM, Heliohost Support wrote: > What is your username, or main domain?>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic0803>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted December 7, 2017 Posted December 7, 2017 We have to use slightly older versions to stay compatible with everything else on the server, but yes it depending on which server you pick it looks like we can do Johnny postgresql 8.4.20 postgis 1.5.3 Ricky postgresql 9.2.23 postgis 2.0.7 Tommy postgresql 9.2.23 postgis 2.0.7 It also looks like the tablefunc extensions (and others) would be available to be created after installing the postgresql-contrib package for the corresponding postgresql version. Please be aware that we've never done this before so the above is merely speculation. Once you have an account created let us know which server you decided to go with and the install can be attempted.
HelioHost Posted December 11, 2017 Author Posted December 11, 2017 OK so I created an account in Tommy called l6 (domain l6.heliohost.org) canwe try installing the required packages for these extensions? Thanks inadvance. On Thu, Dec 7, 2017 at 1:41 PM, Heliohost Support wrote: > We have to use slightly older versions to stay compatible with everything> else on the server, but yes it depending on which server you pick it looks> like we can doJohnny postgresql 8.4.20 postgis 1.5.3Ricky postgresql 9.2.23> postgis 2.0.7Tommy postgersql 9.2.23 postgis 2.0.7It also looks like the> tablefunc extensions (and others) would be available to be created after> installing the postgresql-contrib package for the corresponding postgresql> version. Please be aware that we've never done this before so the above is> merely speculation. Once you have an account created let us know which> server you decided to go with and the install can be attempted.>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic0803>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted December 11, 2017 Posted December 11, 2017 Awesome! Welcome to the community. Let's start with postgis. I just installed it on Tommy, and it appears to be working. The create extension command requires superuser permissions which we can't grant to regular users, but if you let me know your database name that you want it on I can add it for you.
HelioHost Posted December 11, 2017 Author Posted December 11, 2017 Thanks, I sent you the information via PM. Regards. On Sun, Dec 10, 2017 at 9:24 PM, Heliohost Support wrote: > Awesome! Welcome to the community.Let's start with postgis. I just> installed it on Tommy, and it appears to be working. The create extension> command requires superuser permissions which we can't grant to regular> users, but if you let me know your database name that you want it on I can> add it for you.>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic0803>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
Krydos Posted December 11, 2017 Posted December 11, 2017 Postgis and tablefunc extensions have been created on the database you pm'd and remote access has been enabled. Let us know if everything is working as expected.
Recommended Posts