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 1phukk-0002i9-V2 for pgsql-committers@arkaria.postgresql.org; Thu, 30 Mar 2023 16:03:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phukj-0002zB-Rh for pgsql-committers@arkaria.postgresql.org; Thu, 30 Mar 2023 16:03:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phukj-0002z1-JW for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 16:03:53 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phukg-0004WA-U7 for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 16:03:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=W1vtEGTbiQf6R/544hwyg2og6foCnwKn4vHW8OpH5MQ=; b=i7yYk8AngRHuZ8Ld7ROYpoji3G eDtLck/SALIOQDGJ18R8pVikBkZqWpESv0EOhMqnjpdd9NpMGQlcLMWSIEEkTGD7OpuRgI2muIeoH qPTnskaHQzG07otiMp2VqoZRo9KAqvi6of0fGVv+Tp7GMjaTL5CuVS932Bf5TI0NydPg9Py1kxTzn jqXddpMDF8HItENJ14JkKI8Q9uTPfPFuNA01yCSNbje6BJ3gv/7Fa82ZMiybgLchAb6wLhD+yroWT x8z0Dku+narfpugMv0i5Wjxa2ixwo4ZK+IBc2jQPjOR4/9tDd668jJQi/w4Lqxeij+gh++VqYNHGh KOpeU6cA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1phukg-0002Dy-I1 for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 16:03:50 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1phuke-000Ukd-IP for pgsql-committers@lists.postgresql.org; Thu, 30 Mar 2023 16:03:49 +0000 Content-Type: multipart/mixed; boundary="===============8116685080800457991==" MIME-Version: 1.0 From: Robert Haas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add new predefined role pg_create_subscription. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 30 Mar 2023 16:03:49 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8116685080800457991== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIG5ldyBwcmVkZWZpbmVkIHJvbGUgcGdfY3JlYXRlX3N1YnNjcmlwdGlvbi4KClRoaXMgcm9s ZSBjYW4gYmUgZ3JhbnRlZCB0byBub24tc3VwZXJ1c2VycyB0byBhbGxvdyB0aGVtIHRvIGlzc3Vl CkNSRUFURSBTVUJTQ1JJUFRJT04uIFRoZSBub24tc3VwZXJ1c2VyIG11c3QgYWRkaXRpb25hbGx5 IGhhdmUgQ1JFQVRFCnBlcm1pc3Npb25zIG9uIHRoZSBkYXRhYmFzZSBpbiB3aGljaCB0aGUgc3Vi c2NyaXB0aW9uIGlzIHRvIGJlCmNyZWF0ZWQuCgpNb3N0IGZvcm1zIG9mIEFMVEVSIFNVQlNDUklQ VElPTiwgaW5jbHVkaW5nIEFMVEVSIFNVQlNDUklQVElPTiAuLiBTS0lQLApub3cgcmVxdWlyZSBv bmx5IHRoYXQgdGhlIHJvbGUgcGVyZm9ybWluZyB0aGUgb3BlcmF0aW9uIG93biB0aGUKc3Vic2Ny aXB0aW9uLCBvciBpbmhlcml0IHRoZSBwcml2aWxlZ2VzIG9mIHRoZSBvd25lci4gSG93ZXZlciwg dG8KdXNlIEFMVEVSIFNVQlNDUklQVElPTiAuLi4gUkVOQU1FIG9yIEFMVEVSIFNVQlNDUklQVElP TiAuLi4gT1dORVIgVE8sCnlvdSBhbHNvIG5lZWQgQ1JFQVRFIHBlcm1pc3Npb24gb24gdGhlIGRh dGFiYXNlLiBUaGlzIGlzIHNpbWlsYXIgdG8Kd2hhdCB3ZSBkbyBmb3Igc2NoZW1hcy4gVG8gY2hh bmdlIHRoZSBvd25lciBvZiBhIHNjaGVtYSwgeW91IG11c3QgYWxzbwpoYXZlIHBlcm1pc3Npb24g dG8gU0VUIFJPTEUgdG8gdGhlIG5ldyBvd25lciwgc2ltaWxhciB0byB3aGF0IHdlIGRvCmZvciBv dGhlciBvYmplY3QgdHlwZXMuCgpOb24tc3VwZXJ1c2VycyBhcmUgcmVxdWlyZWQgdG8gc3BlY2lm eSBhIHBhc3N3b3JkIGZvciBhdXRoZW50aWNhdGlvbgphbmQgdGhlIHJlbW90ZSBzaWRlIG11c3Qg dXNlIHRoZSBwYXNzd29yZCwgc2ltaWxhciB0byB3aGF0IGlzIHJlcXVpcmVkCmZvciBwb3N0Z3Jl c19mZHcgYW5kIGRibGluay4gIEEgc3VwZXJ1c2VyIHdobyB3YW50cyBhIG5vbi1zdXBlcnVzZXIg dG8Kb3duIGEgc3Vic2NyaXB0aW9uIHRoYXQgZG9lcyBub3QgcmVseSBvbiBwYXNzd29yZCBhdXRo ZW50aWNhdGlvbiBtYXkKc2V0IHRoZSBuZXcgcGFzc3dvcmRfcmVxdWlyZWQ9ZmFsc2UgcHJvcGVy dHkgb24gdGhhdCBzdWJzY3JpcHRpb24uIEEKbm9uLXN1cGVydXNlciBtYXkgbm90IHNldCBwYXNz d29yZF9yZXF1aXJlZD1mYWxzZSBhbmQgbWF5IG5vdCBtb2RpZnkgYQpzdWJzY3JpcHRpb24gdGhh dCBhbHJlYWR5IGhhcyBwYXNzd29yZF9yZXF1aXJlZD1mYWxzZS4KClRoaXMgbmV3IHBhc3N3b3Jk X3JlcXVpcmVkIHN1YnNjcmlwdGlvbiBwcm9wZXJ0eSB3b3JrcyBtdWNoIGxpa2UgdGhlCmVwb255 bW91cyBwb3N0Z3Jlc19mZHcgcHJvcGVydHkuICBJbiBib3RoIGNhc2VzLCB0aGUgYWN0dWFsIHNl bWFudGljcwphcmUgdGhhdCBhIHBhc3N3b3JkIGlzIG5vdCByZXF1aXJlZCBpZiBlaXRoZXIgKDEp IHRoZSBwcm9wZXJ0eSBpcyBzZXQKdG8gZmFsc2Ugb3IgKDIpIHRoZSByZWxldmFudCB1c2VyIGlz IHRoZSBzdXBlcnVzZXIuCgpQYXRjaCBieSBtZSwgcmV2aWV3ZWQgYnkgQW5kcmVzIEZyZXVuZCwg SmVmZiBEYXZpcywgTWFyayBEaWxnZXIsCmFuZCBTdGVwaGVuIEZyb3N0IChidXQgc29tZSBvZiB0 aG9zZSBwZW9wbGUgZGlkIG5vdCBmdWxseSBlbmRvcnNlCmFsbCBvZiB0aGUgZGVjaXNpb25zIHRo YXQgdGhlIHBhdGNoIG1ha2VzKS4KCkRpc2N1c3Npb246IGh0dHA6Ly9wb3N0Z3IuZXMvbS9DQStU Z21vYURIPTBYajdPQmlRbnNIVEtjRjJjNEwrPWd6UEJVS1NKTGg4emVkMl8rRGdAbWFpbC5nbWFp bC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQu cG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9jM2FmZThjZjVhMWU0NjViZDcxZTQ4ZTRiYzcx N2Y1YmZkYzdhN2Q2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpkb2Mvc3JjL3NnbWwv cmVmL2FsdGVyX3N1YnNjcmlwdGlvbi5zZ21sICAgICAgICAgICB8ICAxNiArLS0KZG9jL3NyYy9z Z21sL3JlZi9jcmVhdGVfc3Vic2NyaXB0aW9uLnNnbWwgICAgICAgICAgfCAgMjIgKysrLQpkb2Mv c3JjL3NnbWwvcmVmL2Ryb3Bfc3Vic2NyaXB0aW9uLnNnbWwgICAgICAgICAgICB8ICAgMiArLQpk b2Mvc3JjL3NnbWwvdXNlci1tYW5hZy5zZ21sICAgICAgICAgICAgICAgICAgICAgICB8ICAgNiAr CnNyYy9iYWNrZW5kL2NhdGFsb2cvcGdfc3Vic2NyaXB0aW9uLmMgICAgICAgICAgICAgIHwgICAx ICsKc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsICAgICAgICAgICAgICAgfCAg IDEgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9hbHRlci5jICAgICAgICAgICAgICAgICAgICAgICB8 ICAyNCArKysrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3N1YnNjcmlwdGlvbmNtZHMuYyAgICAgICAg ICAgIHwgMTM4ICsrKysrKysrKysrKysrKysrLS0tLQouLi4vbGlicHF3YWxyZWNlaXZlci9saWJw cXdhbHJlY2VpdmVyLmMgICAgICAgICAgICB8ICA2NSArKysrKysrKy0tCnNyYy9iYWNrZW5kL3Jl cGxpY2F0aW9uL2xvZ2ljYWwvdGFibGVzeW5jLmMgICAgICAgIHwgICA5ICstCnNyYy9iYWNrZW5k L3JlcGxpY2F0aW9uL2xvZ2ljYWwvd29ya2VyLmMgICAgICAgICAgIHwgICA2ICsKc3JjL2JhY2tl bmQvcmVwbGljYXRpb24vd2FscmVjZWl2ZXIuYyAgICAgICAgICAgICAgfCAgIDIgKy0Kc3JjL2Jp bi9wZ19kdW1wL3BnX2R1bXAuYyAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgMTYgKystCnNy Yy9iaW4vcGdfZHVtcC9wZ19kdW1wLmggICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAxICsK c3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICAgICAgICAgICAgICAgfCAgIDIg Ky0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9wZ19hdXRoaWQuZGF0ICAgICAgICAgICAgICAgICAgfCAg IDUgKwpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3N1YnNjcmlwdGlvbi5oICAgICAgICAgICAgICB8 ICAgMyArCnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9uL3dhbHJlY2VpdmVyLmggICAgICAgICAgICAg IHwgIDEyICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3Vic2NyaXB0aW9uLm91dCAgICAg ICAgIHwgIDU3ICsrKysrKystLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zdWJzY3JpcHRpb24uc3Fs ICAgICAgICAgICAgICB8ICA1NCArKysrKysrLQpzcmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMjdf bm9zdXBlcnVzZXIucGwgICAgICAgICB8ICAgMiArLQoyMSBmaWxlcyBjaGFuZ2VkLCAzODQgaW5z ZXJ0aW9ucygrKSwgNjAgZGVsZXRpb25zKC0pCgo= --===============8116685080800457991==--