pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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:48  Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
  parent: Nguyen Hoai Nam <namptit307@gmail.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