I can't create postgis extension in single-user mode in postgres. But I can do that from pgadmin.
Is creating extension in single-user mode even possible? Can find any docs on that.
Full info on my question can be seen there.
-
Do you mean from a psql prompt. Have you checked that you have correct permissions, see the extension docs, which state you typically need superuser or db owner permissions. It is possible you are using psql and pgAdmin with different users?John Powell– John Powell2015-01-27 10:02:36 +00:00Commented Jan 27, 2015 at 10:02
-
Read about single user modeuser1685095– user16850952015-01-27 10:03:50 +00:00Commented Jan 27, 2015 at 10:03
-
I know what single user mode is, but who said you can't use psql to connect to a db in single-user mode.John Powell– John Powell2015-01-27 10:07:00 +00:00Commented Jan 27, 2015 at 10:07
-
You don't need single-user mode. It is only needed for creating the catalogs during bootstrapping. The postgis-extension can be added using normal operations.joop– joop2015-01-27 10:36:19 +00:00Commented Jan 27, 2015 at 10:36
-
Oh really? Enlighten me how to do that with docker when building the image, so that right after the build users would have completely working geospatial database please =) AFAIK there is no solution.user1685095– user16850952015-01-27 10:39:44 +00:00Commented Jan 27, 2015 at 10:39
Add a comment
|
1 Answer
Anyway, right now I have a comment on the PostgreSQL mailing list.
Why in the world would you think that's a good thing to do?
Single-user mode is a barely-documented disaster recovery aid. It's not meant for routine activity. There are a whole lot of behaviors you want that are turned off in single-user mode.
The specific reason why this doesn't work is this bit in heap_create_with_catalog:
/*
* Decide whether to create an array type over the relation's rowtype. We
* do not create any array types for system catalogs (ie, those made
* during initdb). We do not create them where the use of a relation as
* such is an implementation detail: toast tables, sequences and indexes.
*/
if (IsUnderPostmaster && (relkind == RELKIND_RELATION ||
relkind == RELKIND_VIEW ||
relkind == RELKIND_MATVIEW ||
relkind == RELKIND_FOREIGN_TABLE ||
relkind == RELKIND_COMPOSITE_TYPE))
new_array_oid = AssignTypeArrayOid();
We could possibly develop some other mechanism for detecting whether we're within the initdb sequence, but I can't get very excited about treating this as a bug. Single-user mode hasn't been considered a standard user environment since maybe the early 90s.
1 Comment
Homme Zwaagstra
It's interesting to note that single user mode is 'highly recommended' for initialisation tasks in the official Docker Postgres image.