[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] Create extension without superuser
From: Alvaro Aguayo Garcia-Rada <aaguayo () opensysperu ! com>
Date: 2016-07-14 4:48:35
Message-ID: h6blkum78rldsrvihgeng2n3.1468471039937 () email ! android ! com
[Download RAW message or body]
"CREATE EXTENSION" is not itself restricted to superuser. However, various =
extensions will create different objects for it's usage: schemas, tables, t=
ypes, functions, casts, etc. To "CREATE EXTENSION" as a non-superuser, the =
user must have required privileges to create all the objects required by th=
e extension. The full SQL script for each extension can be found on /usr/sh=
are folder(/usr/share/postgresql/9.4/extension ; may vary by version and di=
stro)
So, to know wheter a non-superuser can run "CREATE EXTENSION btree_gist;", =
we need to check the installation script for btree_gist. And, unfortunatell=
y 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 privi=
lege, 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 autom=
atically created on any new database. If you need it on other databases, yo=
u can just install it.
Regards,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1)=C2=A03377813=C2=A0| RPM: #034252 / (+51)=C2=A0995540103=C2=
=A0 | RPC: (+51)=C2=A0954183248
Website:=C2=A0www.ocs.pe
Sent from my Sony Xperia=E2=84=A2 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.
[Attachment #3 (text/html)]
<html><body><div><p dir="ltr">"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)</p> <p dir="ltr">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.</p> <p dir="ltr">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.</p> <p \
dir="ltr">Regards,</p> <p dir="ltr">Alvaro Aguayo<br>
Jefe de Operaciones<br>
Open Comb Systems E.I.R.L.</p>
<p dir="ltr">Oficina: (+51-1) 3377813 | RPM: #034252 / \
(+51) 995540103  | RPC: (+51) 954183248<br> Website: <a \
href="http://www.ocs.pe">www.ocs.pe</a></p> <p dir="ltr">Sent from my Sony \
Xperia™ smartphone</p> <br><br>---- Nguyen Hoai Nam wrote \
----<br><br></div><br><div><div dir="ltr"><div><div>Hi \
everyone.<br><br></div>Currently, I would like to create btree_gist with normal user. \
Do you have any suggesstion to do it?<br><br></div>Thank you.<br></div> \
</div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic