Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdnyu-0003Bl-AW for pgsql-admin@arkaria.postgresql.org; Fri, 22 Oct 2021 06:24:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdnys-0002DA-ER for pgsql-admin@arkaria.postgresql.org; Fri, 22 Oct 2021 06:24:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdnys-0002D0-4P for pgsql-admin@lists.postgresql.org; Fri, 22 Oct 2021 06:24:42 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdnyp-0004eT-4L for pgsql-admin@lists.postgresql.org; Fri, 22 Oct 2021 06:24:41 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id B22C73805AE; Fri, 22 Oct 2021 08:24:37 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lY2dxR67f-d9; Fri, 22 Oct 2021 08:24:37 +0200 (CEST) Received: from [192.168.178.197] (ip-37-201-154-229.hsi13.unitymediagroup.de [37.201.154.229]) by rs.plausibolo.de (Postfix) with ESMTPSA id 5C9FE38056A; Fri, 22 Oct 2021 08:24:37 +0200 (CEST) Message-ID: Date: Fri, 22 Oct 2021 08:24:34 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.2.0 Subject: Re: RDS and postgres extension approval Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <931ded5b-c8da-5ebc-9f48-637d9a3de015@gmail.com> From: Holger Jakobs In-Reply-To: <931ded5b-c8da-5ebc-9f48-637d9a3de015@gmail.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------0xTb8Q5TwAvCk06JjLIkjl97" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------0xTb8Q5TwAvCk06JjLIkjl97 Content-Type: multipart/mixed; boundary="------------cBja6RnpLwLMzY0dCUt9Wr4h"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: RDS and postgres extension approval References: <931ded5b-c8da-5ebc-9f48-637d9a3de015@gmail.com> In-Reply-To: <931ded5b-c8da-5ebc-9f48-637d9a3de015@gmail.com> --------------cBja6RnpLwLMzY0dCUt9Wr4h Content-Type: multipart/alternative; boundary="------------E1AwBUt0LDUHOjQI7zqyAOZb" --------------E1AwBUt0LDUHOjQI7zqyAOZb Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGVyZSBpcyB0aGUgZG9jOiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzE0L3hw bGFuZy1pbnN0YWxsLmh0bWwNCg0KSW4gY2FzZSB5b3Ugd2FudCB0byBkbyBzZXJ2ZXIgcHJv Z3JhbW1pbmcgd2l0aCBhIHNjcmlwdGluZyBsYW5ndWFnZSwgdHJ5IA0KdGhlIFRvb2wgQ29t bWFuZCBMYW5ndWFnZS4NCg0KDQpBbSAyMi4xMC4yMSB1bSAwNDoyOCBzY2hyaWViIFJvbjoN Cj4gT24gMTAvMjEvMjEgODo1MCBQTSwgRGF2aWQgRy4gSm9obnN0b24gd3JvdGU6DQo+PiBP biBUaHUsIE9jdCAyMSwgMjAyMSBhdCA2OjQ4IFBNIFdlbGxzIE9saXZlciA8d2VsbHMub2xp dmVyQGdtYWlsLmNvbT4gDQo+PiB3cm90ZToNCj4+DQo+PiAgICAgSXMgdGhlcmUgYW55dGhp bmcgb3V0IHRoZXJlIHdyaXR0ZW4gYWJvdXQgd2hhdCB0cnVzdGVkIG1lYW5zPyBUaGUNCj4+ ICAgICBQRyBjb21tdW5pdHkgc2VlbXMgcHJldHR5IHRydXN0aW5nIDopDQo+Pg0KPj4NCj4+ IEl0IGJhc2ljYWxseSBtZWFucyB0aGUgcHJvZ3JhbW1pbmcgbGFuZ3VhZ2UgYWxsb3dzIHRo ZSBhdXRob3Igb2YgdGhlIA0KPj4gY29kZSB0bypicmVhayBvdXQgb2YgdGhlIHNlcnZlciBh bmQgYWNjZXNzIHRoZSB1bmRlcmx5aW5nIG9wZXJhdGluZyANCj4+IHN5c3RlbSogYXMgdGhl IHBvc3RncmVzIHVzZXIuwqAgSSBiZWxpZXZlIHRoaXMgaXMgd3JpdHRlbiBpbiB0aGUgZG9j cyANCj4+IC0gYnV0IEkgaGF2ZW4ndCBzZWFyY2hlZCByZWNlbnRseS4NCj4+DQo+IFdoaWNo IC0tIGJ5IGRlc2lnbiAtLSBSRFMgd29uJ3QgbGV0IHlvdSBkby7CoCBUaHVzLCB0aGUgbGFj ayBvZiANCj4gdW50cnVzdGVkIG1vZHVsZXMuDQo+DQo+IC0tIA0KPiBBbmd1bGFyIG1vbWVu dHVtIG1ha2VzIHRoZSB3b3JsZCBnbyAncm91bmQuDQoNCi0tIA0KSG9sZ2VyIEpha29icywg QmVyZ2lzY2ggR2xhZGJhY2gsIFRlbC4gKzQ5LTE3OC05NzU5MDEyDQoNCg== --------------E1AwBUt0LDUHOjQI7zqyAOZb Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Here is the doc: https://www.postgresql.org/docs/14/xplang= -install.html

In case you want to do server programming with a scripting language, try the Tool Command Language.


Am 22.10.21 um 04:28 schrieb Ron:
On 10/21/21 8:50 PM, David G. Johnston wrote:
On Thu, Oct 21, 2021 at 6:48 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Is there anything out there written about what trusted means? The PG community seems pretty trusting :)


It basically means the programming language allows the author of the code to break out of the server and access the underlying operating system as the postgres user.=C2=A0 I believe this is written in = the docs - but I haven't searched recently.

Which -- by design -- RDS won't let you do.=C2=A0 Thus, the lack of= untrusted modules.

--
Angular momentum makes the world go 'round.
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------E1AwBUt0LDUHOjQI7zqyAOZb-- --------------cBja6RnpLwLMzY0dCUt9Wr4h-- --------------0xTb8Q5TwAvCk06JjLIkjl97 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYXJZIgUDAAAAAAAKCRCKV5yTsxlhunpR AJ483xkdwJk2rwEXQbOCnFoNRmESZgCeMKQLKfMhsF9R2tjwxv0Nkt53kfc= =jHTT -----END PGP SIGNATURE----- --------------0xTb8Q5TwAvCk06JjLIkjl97--