Jump to content


Photo

[HH#507899] not able to install postgis


  • Please log in to reply
9 replies to this topic

#1 HelioHost

HelioHost

    Announcements

  • Moderators
  • 4,597 posts
  • Gender:Not Telling

Posted 03 December 2018 - 05:00 PM

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 or
directory

*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?
This is an unmonitored account for announcements only.
Wiki | Facebook | Twitter
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#2 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 9,372 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 03 December 2018 - 05:30 PM

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.


Please do not PM me for support. Posting on our forums lets all of us learn.

Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#3 onroute

onroute

    Newbie

  • Members
  • 1 posts

Posted 03 December 2018 - 06:08 PM

database : onroute_testdb



#4 HelioHost

HelioHost

    Announcements

  • Moderators
  • 4,597 posts
  • Gender:Not Telling

Posted 03 December 2018 - 06:08 PM

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...p?showtopic4657
>
> Thank you,
> Heliohost support
> https://www.heliohost.org/
> https://www.helionet.org/
>
>
This is an unmonitored account for announcements only.
Wiki | Facebook | Twitter
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#5 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 17,180 posts
  • Gender:Male

Posted 03 December 2018 - 07:01 PM

Extension created.

#6 HelioHost

HelioHost

    Announcements

  • Moderators
  • 4,597 posts
  • Gender:Not Telling

Posted 03 December 2018 - 07:40 PM

*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...p?showtopic4657
>
> Thank you,
> Heliohost support
> https://www.heliohost.org/
> https://www.helionet.org/
>
>
This is an unmonitored account for announcements only.
Wiki | Facebook | Twitter
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#7 HelioHost

HelioHost

    Announcements

  • Moderators
  • 4,597 posts
  • Gender:Not Telling

Posted 03 December 2018 - 07:41 PM

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...p?showtopic4657
>>
>> Thank you,
>> Heliohost support
>> https://www.heliohost.org/
>> https://www.helionet.org/
>>
>>
This is an unmonitored account for announcements only.
Wiki | Facebook | Twitter
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#8 wolstech

wolstech

    Rank X Member

  • Root Admin
  • 9,372 posts
  • Gender:Male
  • Location:Pennsylvania

Posted 03 December 2018 - 08:10 PM

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.


Please do not PM me for support. Posting on our forums lets all of us learn.

Do you play Minecraft? | Server Monitors | And the Dumbass of the Decade award goes to...


#9 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 17,180 posts
  • Gender:Male

Posted 03 December 2018 - 09:11 PM

Postgis is version 2.0.7-1.el7 which is the latest version that can be installed at this time.

#10 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 17,180 posts
  • Gender:Male

Posted 03 December 2018 - 09:13 PM

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/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users