HelioHost Posted December 3, 2018 Posted December 3, 2018 Username: onroute, Server: Johnny, Main domain: onroute.heliohost.org hi , username : onroute i am trying to install postgis extension in newlt created database but i am getting following error *SQL error:* ERROR: could not open extension control file"/usr/share/pgsql/extension/postgis.control": No such file ordirectory *In statement:*CREATE EXTENSION postgis can u please let me know what's happening?? is it related to some user permissions? can u do that for me?
wolstech Posted December 3, 2018 Posted December 3, 2018 Our root admin Krydos has to install postgis on databases, users cannot do it themselves. What database needs it installed? Once we know the database name, he should be able to do it when he sees this.
HelioHost Posted December 3, 2018 Author Posted December 3, 2018 database : onroute_testdb user : onroute On Mon, Dec 3, 2018 at 11:00 PM Heliohost Support wrote: > Our root admin Krydos has to install postgis on databases, users cannot do> it themselves. What database needs it installed?> > Once we know the database name, he should be able to do it when he sees> this.>>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic4657>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
HelioHost Posted December 3, 2018 Author Posted December 3, 2018 *SQL error:* ERROR: function st_linefromencodedpolyline(unknown) does not exist is this postgis version related api issue ? can i get this version.. i needthis. On Tue, Dec 4, 2018 at 12:31 AM Heliohost Support wrote: > Extension created.>> You may view the status of your ticket by visiting:>> https://www.helionet.org/index/index.php?showtopic4657>> Thank you,> Heliohost support> https://www.heliohost.org/> https://www.helionet.org/>>
HelioHost Posted December 3, 2018 Author Posted December 3, 2018 this is present in Availability: 2.2.0 onwards. On Tue, Dec 4, 2018 at 1:09 AM kunal tayal wrote: > *SQL error:*>> ERROR: function st_linefromencodedpolyline(unknown) does not exist>>> is this postgis version related api issue ? can i get this version.. i> need this.>> On Tue, Dec 4, 2018 at 12:31 AM Heliohost Support > wrote:>>> Extension created.>>>> You may view the status of your ticket by visiting:>>>> https://www.helionet.org/index/index.php?showtopic4657>>>> Thank you,>> Heliohost support>> https://www.heliohost.org/>> https://www.helionet.org/>>>>
wolstech Posted December 3, 2018 Posted December 3, 2018 You should be able to check the version from phppgadmin. I believe SELECT PostGIS_full_version(); will get the version information for postgis. I was trying to run it myself, but I don't have a database with that extension on it, so the function doesn't exist for me.
Krydos Posted December 3, 2018 Posted December 3, 2018 Postgis is version 2.0.7-1.el7 which is the latest version that can be installed at this time.
Krydos Posted December 3, 2018 Posted December 3, 2018 This is the newest version that can be installed on a shared hosting plan, but if you need a newer version than 2.0.7-1.el7 it could be installed just for you on a vps https://www.heliohost.org/vps/
Recommended Posts