Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [postgresql-extensions]

Additional modules supplied by the Postgres project but not installed by default.

Postgres supplies additional modules not installed in the standard distribution.
The complete list in the current manual.

Before you can use CREATE EXTENSION to load an extension into a database, the extension's supporting files must be installed. There are additional software packages for all common OS available, pre-installed on most DB hosting services, but not all extensions are available on some.

This tag is about issues revolving around handling extensions, not discussing a particular one in depth.

105 questions
68
votes
3 answers

How to install the additional module pg_trgm

I just want to know how to install the module pg_tgrm as used in the trigram indexing scheme that allows you to do un-anchored search patterns on an index. WHERE foo LIKE '%bar%';
Lizardie
  • 813
  • 1
  • 6
  • 8
30
votes
1 answer

PostgreSQL two different ways to generate a UUID: gen_random_uuid vs uuid_generate_v4?

What is the difference between the following two functions gen_random_uuid() provided by pgcrypto extension uuid_generate_v4() provided by uuid-ossp extension Are they both the same behind the scenes? Any performance impacts on using one?
user148246
18
votes
2 answers

How do I install/enable the uuid-ossp extension on Postgres 9.3?

I’m using Postgres 9.3 on Ubuntu Linux 14.04. How do I install/enable the uuid-ossp extension? I first verified the contrib package was installed … root@prodbox:/home/rails/myproject# apt-get install postgresql-contrib Reading package lists...…
Dave
  • 753
  • 10
  • 22
  • 39
17
votes
1 answer

Postgresql enabling extensions without super-user

I have a PostgreSQL 9.5 server on which I have scripts that create roles and databases for users automatically. Within these databases it would be helpful to enable specific extensions (e.g. pgcrypto), but as I understand it one must be a superuser…
beldaz
  • 1,740
  • 3
  • 16
  • 26
13
votes
2 answers

Is it recommended to install extensions into pg_catalog schema?

Since objects in pg_catalog schema are implicitly in the search_path (docs), would it be recommended to install extensions in that schema?
zam6ak
  • 481
  • 1
  • 4
  • 13
11
votes
2 answers

Couldn't open extension control file plpython3u.control : No such file or directory

I want to have python3 in my postgresql database for writing stored procedures. Being in the psql client, when I enter the command create extension plpython3u I get the error: couldn't open extension control file…
Stephane Rolland
  • 8,911
  • 11
  • 33
  • 40
8
votes
1 answer

How to select functions that belong in a given extension in PostgreSQL?

I am trying to compose a SELECT from pg_catalog that pulls function name, its schema name and the name of extension that created this function. To pull function list I use (a simplified version) SELECT pg_proc.proname, pg_namespace.nspname AS…
oᴉɹǝɥɔ
  • 551
  • 5
  • 11
8
votes
2 answers

list of PostgreSQL trusted languages?

I am trying to find a list of PostgreSQL trusted procedural languages (PL) as I often need to use a PL in a non-superuser environment. But I couldn't find a definitive answer. For example, the Postgres documentation here suggest that there is a…
tinlyx
  • 3,810
  • 14
  • 50
  • 79
8
votes
1 answer

Creating UUID extension as the non super privileged user

I need to load the uuid extension on my database, which is being created in runtime. The user that created the db is not superuser, she only has the "CREATEDB" permissions. Is there a way to do this? Thanks.
Alex
  • 2,775
  • 2
  • 18
  • 7
7
votes
1 answer

How exactly does trigram word-similarity work?

The docs on the word_similarity function say: Returns a number that indicates how similar the first string to the most similar word of the second string. The function searches in the second string a most similar word not a most similar substring.…
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
6
votes
1 answer

PostgreSQL 9.3 Amazon RDS gives error while using UUID-OSSP extension for generating uuid

I have created DB instance on RDS and used below function. It gave error while with the same PostgreSQL version on a local development machine it works fine. create or replace function uuid() returns uuid as 'uuid-ossp', 'uuid_generate_v1' volatile…
Rameshwar RV
  • 161
  • 1
  • 5
6
votes
1 answer

PostgreSQL 8.4: How to tell if a procedural language is installed or not?

I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I need to make sure the language is installed or the app will fail. I don't want to drop the language and re-add it, as that could screw some…
Jeremy Holovacs
  • 1,271
  • 4
  • 20
  • 27
6
votes
1 answer

Custom location for postgis extension .control file

I am trying to install the postgis extension on my database, which resides on a web hosting service. The problem is that the control files seem to have to be found in /package/host/localhost/postgresq-9.3.2-1. I am using a hosting company where all…
wfgeo
  • 191
  • 1
  • 5
6
votes
2 answers

Extension created for public schema not available within database

So, I create the citext extension for schema public and I can see it's there, but then it's not available within the database in that schema. The database is in public as well, because it's created from the postgres user and no schema is specified…
Milkncookiez
  • 479
  • 2
  • 6
  • 16
5
votes
3 answers

how to match pg_repack binary and db version

I am using this command sudo apt-get install postgresql-11-repack to install pg_repack(default to 1.4.8). postgresql-11-repack is already the newest version (1.4.8-1.pgdg20.04+1). when i run "create extension pg_repack" in rds postgres 11, it…
Falcon
  • 101
  • 8
1
2 3 4 5 6 7