Jump to content


Photo

[Solved] Install PostgreSQL extension

postgresql

  • Please log in to reply
4 replies to this topic

#1 kr4cher

kr4cher

    Newbie

  • Members
  • 4 posts
  • Gender:Male

Posted 18 November 2020 - 06:23 PM

Hi, I'd like to have the PostgreSQL uuid-ossp extension installed to generate UUIDs. Is it possible to install it?

 

Server: tommy

DBs:

kr4cher_teamguard

kr4cher_teamguard_test

 

Thanks in advance!

kr4cher



#2 Luigi123

Luigi123

    Rank X Member

  • Moderators
  • 2,535 posts
  • Gender:Male
  • Location:Winnipeg, Manitoba, Canada

Posted 18 November 2020 - 06:47 PM

I don’t think we are able to install that extension on the shared host since you need a paid VPS server if I remember correctly. We had another user from last time that wanted to install this extension like you and apparently, this extension is required to install on a VPS server.
Posted ImagePosted ImagePosted Image
Posted ImagePosted ImagePosted Image

#3 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 21,402 posts
  • Gender:Male

Posted 18 November 2020 - 10:46 PM

Some extensions are available to be installed on shared hosting, but apparently this one is not available. It's supposed to be included in postgresql-contribs package, which is installed, but it's not in there. It looks like Luigi is correct, you'll need a VPS for this.



#4 kr4cher

kr4cher

    Newbie

  • Members
  • 4 posts
  • Gender:Male

Posted 19 November 2020 - 03:39 PM

Okay, then it looks like I have to generate it server-side.

 

Thanks anyway for the feedback!



#5 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 21,402 posts
  • Gender:Male

Posted Today, 04:51 AM

While I was creating extensions on someone else's postgresql database I figured out a way to install uuid-ossp. I went ahead and successfully created it on both of your databases for you. Sorry I couldn't figure it out the other day. I was really surprised when it didn't work.







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users