Additional modules supplied by the Postgres project but not installed by default.
0
votes
0answers
5 views
Is it possible to build PostGIS extensions without building the entire project?
PostGIS has an extension called postgis_tiger_geocoder, I have a few questions about it (all pretty tied together),
Is it possible to build that without building the rest of PostGIS?
If so, can I use ...
2
votes
0answers
43 views
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 ...
0
votes
0answers
17 views
How to initialize a PostGIS database in PostgreSQL single-user mode?
I'm using PostgreSQL 9.2.15 with PostGIS 2.0.7 through the standard packages available on CentOS 7 with EPEL.
I have a server script to automatically setup a PostGIS database, by first executing ...
2
votes
1answer
51 views
Connect as postgres user on AWS RDS to install extension to pg_catalog
I need to connect to our AWS RDS PostgreSQL 9.5 instance so I can add the citext extension to pg_catalog schema so it is available to all schemas (PG prepends pg_catalog to the beginning of the ...
1
vote
1answer
432 views
PostgreSQL: Installing a contrib extension on windows
I am trying to install this Temporal Tables extension into my localhost installation of PostgreSQL. (pg9.4, windows 7)
I have figured out I needed to put the files into the 9.4/share/contrib folder (...
1
vote
0answers
48 views
Require Language In PostgreSQL Extension Control File
I'm developing a custom extension that uses plpythonu in several functions. I'd like to be able to require that plpythonu be installed in order to create my extension, but I don't see anything in the ...
4
votes
2answers
1k views
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?
2
votes
1answer
274 views
When does pg_dump not export CREATE EXTENSION? [on hold]
I have a production database that I am trying to dump then load (in plain text format) locally.
The problem is, the database being dumped uses the hstore extension in several tables, and contrary to ...
3
votes
1answer
973 views
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 ...
2
votes
2answers
720 views
Why does 'plpgsql' not appear in the pg_extension table?
I have two Postgres 9.1 installations. One works properly, the other does not.
On the working installation:
dc=# select * from pg_extension;
extname | extowner | extnamespace | extrelocatable | ...
2
votes
1answer
2k views
Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux
I'm trying to create extension under postgresql 9.1 (Linux):
CREATE EXTENSION pg_trgm;
but got error:
ERROR: could not open extension control file "/usr/share/pgsql/extension/pg_trgm.control": No ...
3
votes
1answer
2k views
PostgreSQL CREATE EXTENSION file not found error on Mac OS
On PostgreSQL 9.2.3 when trying this:
CREATE EXTENSION btree_gist;
I get this error:
ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": No ...
2
votes
1answer
1k views
PostgreSQL 8.4 no levenshtein fuzzymatching?
I'm using debian squeeze package, it says function does not exist?
6
votes
1answer
2k views
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?
...
