From: amandeep singh <singh_a@live.in>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Terminate connections using non-superuser
Thread-Topic: Terminate connections using non-superuser
Thread-Index: AQHTC4vorOYAHTJYrkuEAy7MEQQ4sw==
Date: Wed, 2 Aug 2017 12:36:05 +0000
Message-ID: 
 <MA1PR01MB0748C1F4891FAC8DFB843E6480B00@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [qE4QvMNh5hYvs7EBr588AtO6gVxv4anr4geexUGMmaE=]
x-ms-publictraffictype: Email
x-microsoft-exchange-diagnostics: 
 1;SG2APC01HT087;7:EbWeG7k/UzF0AAFDniC0gJJzkTVJ8Y5/lC6B8aHGTpBtL48lngQWCYd8G17tnDbYxUInollTSnrR6Ms4SO/PTuYX0ouCxHZdoFNrqPfaF9yyCDzxji8jbJIB79FPRLopBSDP+bjawl4pP5bR1hG2TAbXemmIkvPW4ikLWtPQi0SiGZzGxEW89FEGTbWeGkvHZEbVZKj7ccXG0OcGg1pagd7RMtNm2WQP2l4A+xOzu4Vu4cD839cPjXTu4CAbvq+2SR9Kb+vg72i76pmson8KnZnFUWT8kRyEZCrrHMv534Hm20y8kIP9IJ0kYzOwMtsVRYD/IjjeL3MrKAtRBG6+s1LZEid7Bs7+TXbTSrkrfCWck7AE/LTPlbSG32CkElQWeyVPfICd2n8TR1u2OM55G1ghFzmAOXkdq19dt62QG2GG+95fmAM4z2gEvyZul5seZfnhzvEyhSGDKVGsIbKa7I4IcQPhL/ZA1vI7eIluUpw2T1KVHFnQ7Ba/8pjFwANdp1nW7WiaehdmoL+eo3oi037ALLn9Sh5CYMOFuJTXbKllI2Zs51gEfHrTpxCUeC3+DZerbkUAVlxAEIoypXU4+9Cp16/XjKKXscBWIHGgU4f6BNsGc3pTdSEZWE6mVC71MBcnDbeHhmmUr7x9LP8pwJ5f9WdC0YFz1gb7kUMy8UvQeu7r1FDgu5x1iOIxjVhgwFuci5N9MsapMQOQxf9EOrKpAVz9euPhWhBNlJzr3v7q7kkotagi/7ogsWgyEdLIgrbhM/9A8v0Sqlwshf9wXQ==
x-incomingheadercount: 43
x-eopattributedmessage: 0
x-forefront-antispam-report: 
 EFV:NLI;SFV:NSPM;SFS:(7070007)(98901004);DIR:OUT;SFP:1901;SCL:1;SRVR:SG2APC01HT087;H:MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en;
x-ms-office365-filtering-correlation-id: e1dcf2df-018f-4ac0-b513-08d4d9a30b9b
x-microsoft-antispam: 
 UriScan:;BCL:0;PCL:0;RULEID:(300000500095)(300135000095)(300000501095)(300135300095)(22001)(300000502095)(300135100095)(300000503095)(300135400095)(201702061074)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031324274)(2017031323274)(2017031322377)(1601125374)(1603101448)(1701031045)(300000504095)(300135200095)(300000505095)(300135600095)(300000506095)(300135500095);SRVR:SG2APC01HT087;
x-ms-traffictypediagnostic: SG2APC01HT087:
x-exchange-antispam-report-test: UriScan:;
x-exchange-antispam-report-cfa-test: 
 BCL:0;PCL:0;RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(444000031);SRVR:SG2APC01HT087;BCL:0;PCL:0;RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095);SRVR:SG2APC01HT087;
x-forefront-prvs: 0387D64A71
spamdiagnosticoutput: 1:99
spamdiagnosticmetadata: NSPM
Content-Type: multipart/alternative;
	boundary="_000_MA1PR01MB0748C1F4891FAC8DFB843E6480B00MA1PR01MB0748INDP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Aug 2017 12:36:05.3576
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Internet
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SG2APC01HT087
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--_000_MA1PR01MB0748C1F4891FAC8DFB843E6480B00MA1PR01MB0748INDP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All


I have a requirement where I need a non-superuser who can view (pg_stat_act=
ivity) and terminate (pg_terminate_backend) connections of other users. Is =
it possible to give such privileges to non-superuser?


Postgres Version :PostgreSQL9.6


Thanks and Regards:
Amandeep Singh

--_000_MA1PR01MB0748C1F4891FAC8DFB843E6480B00MA1PR01MB0748INDP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
</head>
<body dir=3D"ltr">
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Helvetica,sans-serif;" dir=3D"ltr">
<p>Hi All</p>
<p><br>
</p>
<p>I have a requirement where I need a non-superuser who&nbsp;can view (pg_=
stat_activity) and terminate&nbsp;(pg_terminate_backend)&nbsp;connections o=
f other users. Is it possible to give such privileges to non-superuser?</p>
<p><br>
</p>
<p>Postgres Version :PostgreSQL9.6</p>
<p><span style=3D"font-size: 12pt;">&nbsp;</span><br>
</p>
<p><br>
</p>
<div id=3D"Signature">Thanks and Regards:
<div>Amandeep Singh</div>
</div>
</div>
</body>
</html>

--_000_MA1PR01MB0748C1F4891FAC8DFB843E6480B00MA1PR01MB0748INDP_--