pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Create extension without superuser 2+ messages / 2 participants [nested] [flat]
* Create extension without superuser @ 2016-07-14 04:08 Nguyen Hoai Nam <namptit307@gmail.com> 2016-07-14 04:48 ` Re: Create extension without superuser Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> 0 siblings, 1 reply; 2+ messages in thread From: Nguyen Hoai Nam @ 2016-07-14 04:08 UTC (permalink / raw) To: pgsql-admin Hi everyone. Currently, I would like to create btree_gist with normal user. Do you have any suggesstion to do it? Thank you. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Create extension without superuser 2016-07-14 04:08 Create extension without superuser Nguyen Hoai Nam <namptit307@gmail.com> @ 2016-07-14 04:48 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> 0 siblings, 0 replies; 2+ messages in thread From: Alvaro Aguayo Garcia-Rada @ 2016-07-14 04:48 UTC (permalink / raw) To: pgsql-admin@postgresql.org, Nguyen Hoai Nam <namptit307@gmail.com> "CREATE EXTENSION" is not itself restricted to superuser. However, various extensions will create different objects for it's usage: schemas, tables, types, functions, casts, etc. To "CREATE EXTENSION" as a non-superuser, the user must have required privileges to create all the objects required by the extension. The full SQL script for each extension can be found on /usr/share folder(/usr/share/postgresql/9.4/extension ; may vary by version and distro) So, to know wheter a non-superuser can run "CREATE EXTENSION btree_gist;", we need to check the installation script for btree_gist. And, unfortunatelly for you, it cannot be run without being superuser. The reason is that it creates scalar types. Scalar types can only be created with superuser privilege, as a bad scalar type definition can lead to server crash. Your best option is to install btree_gist in template1, so it will be automatically created on any new database. If you need it on other databases, you can just install it. Regards, Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L. Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51) 954183248 Website: www.ocs.pe Sent from my Sony Xperia™ smartphone ---- Nguyen Hoai Nam wrote ---- Hi everyone. Currently, I would like to create btree_gist with normal user. Do you have any suggesstion to do it? Thank you. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-07-14 04:48 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-07-14 04:08 Create extension without superuser Nguyen Hoai Nam <namptit307@gmail.com> 2016-07-14 04:48 ` Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox