Installing missing postgres extensions manually?
by evening shadow from LinuxQuestions.org on (#6DX8P)
Hello, so I'm a little lost here
In postgres, some extensions like hstore, earthdistance or cube can be found in a separate postgresql-contrib package in other distros and then be loaded into any database running the query "CREATE EXTENSION cube;" for examle
In slackware though, after installing postgres from slackbuilds.org, it comes already with SOME extensions that would normally be found in the contrib package (e.g. hstore) by default, but others are missing (e.g. cube, which is the one I'm needing to use right now) and there's no postgresql-contrib package here
Anyone knows how to go about installing these missing extensions manually? I've had no luck finding useful information, since most of it is for other distros and they just tell you to install the contrib package
Using postgres version 14.7 currently in case that helps
In postgres, some extensions like hstore, earthdistance or cube can be found in a separate postgresql-contrib package in other distros and then be loaded into any database running the query "CREATE EXTENSION cube;" for examle
In slackware though, after installing postgres from slackbuilds.org, it comes already with SOME extensions that would normally be found in the contrib package (e.g. hstore) by default, but others are missing (e.g. cube, which is the one I'm needing to use right now) and there's no postgresql-contrib package here
Anyone knows how to go about installing these missing extensions manually? I've had no luck finding useful information, since most of it is for other distros and they just tell you to install the contrib package
Using postgres version 14.7 currently in case that helps