Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rspmH-009ZNW-KA for pgsql-general@arkaria.postgresql.org; Fri, 05 Apr 2024 20:03:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rspmG-004ssv-Hn for pgsql-general@arkaria.postgresql.org; Fri, 05 Apr 2024 20:03:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rspmG-004ssl-6j for pgsql-general@lists.postgresql.org; Fri, 05 Apr 2024 20:03:08 +0000 Received: from mail-oo1-xc2a.google.com ([2607:f8b0:4864:20::c2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rspmD-000nkq-Ji for pgsql-general@lists.postgresql.org; Fri, 05 Apr 2024 20:03:06 +0000 Received: by mail-oo1-xc2a.google.com with SMTP id 006d021491bc7-5a49261093cso1189565eaf.3 for ; Fri, 05 Apr 2024 13:03:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712347385; x=1712952185; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=wBT9qDkwt2zhHRTD3xh1DSvqwBA0pbD/HfM3vWWBCx8=; b=ZxHDKAOpsdNPabTDcqZI9B5TEuM0CXz2rP6R2Mjn5eKM2qVf64AhJt6S8yetfhKpzu Mfyh2m2mwKArL5W9UBocBomPbUoJFm6n+PYnex6eKQTNxlj9w7NnSApPmH/QMHO6rzg4 eZgcQHnGA5VQxbK/3/v/Pl88O4ENH/lATvlyrThSC+dtRjlMW7xZVuiatBotSLhfeQe+ npf/OWq0fXZAWpfpg3otga+LtOhHhdW2cn8rNXp0iaPfX2RQ9JyQC8XKjS3fw42E/KS9 pe1I8CYPEieqbbQGCdvQvLeuX9eNUnzPFVNM7iSs4jRFlprw0xQfyWXnRkVlsTqHrLrl OnBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712347385; x=1712952185; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=wBT9qDkwt2zhHRTD3xh1DSvqwBA0pbD/HfM3vWWBCx8=; b=a+9aWnGbqtBGRQp7cqSV+IwUQbPgobJASiP4i+0MUy+3DgEs86sAtMiAizPURwq1/b 9K7FQ9iQvSDRw0YIi234IjkDQdoBu8OYRNRFjYxFliDcIbjM3nZ7RQGJFDcerAPe4bP9 Y8Kjjc/D48X0SOLKAiLOiFf24/GOz9AFqxMhpmbZWzSRSXiEDYL8EESYVKFLYBIK6myw R/lE9RS9+tUWOqvwn0yTYL2BcnKukGjvKtzOsWJk0sNJdMCwuey0aMxk+NvcQYcbtqU7 HFbG5NnoAK6qFpAnrdh9I5Nwk3RJTeGnC5hFqn2B0qHdYqxNlrlZpyZlO9NaQ6LG9i5k AnzQ== X-Gm-Message-State: AOJu0YyzPZQ5gqXplozVcnOBFFprsINu/JhqqoKyJIp9+Djvz44Q3KMy RUOpLtgCI2BAlDSKMFdRb6zb9Y+BpNf/iY8fa9tkU2hqiTYCQqBeas2ecyx3D3sVxCOUeZYLnDB OnwChOxtOj+cNQ9/DHrPftKDSorujftR5sMo= X-Google-Smtp-Source: AGHT+IGmDbg7WxUN2pNKOxXLc7GxHW9Qq7Z+uGd32GIRTmm4yjMVAH1DZsMzSc9YYEI8VW25lnDVni4YLbwIPbHRTUQ= X-Received: by 2002:a05:6820:2184:b0:5a1:cefd:73d6 with SMTP id ce4-20020a056820218400b005a1cefd73d6mr2945236oob.7.1712347384787; Fri, 05 Apr 2024 13:03:04 -0700 (PDT) MIME-Version: 1.0 From: "David G. Johnston" Date: Fri, 5 Apr 2024 13:02:29 -0700 Message-ID: Subject: Role Graph for PostgreSQL (v16+) v1-Beta To: PostgreSQL General Content-Type: multipart/alternative; boundary="0000000000009a38ad06155ef1e0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009a38ad06155ef1e0 Content-Type: text/plain; charset="UTF-8" Hey All, Last year with the revisions to CREATEROLE I decided that having a view that allowed one to more readily see the membership graph of their cluster would be useful. I originally tried to write something up for psql but decided that was impractical given its requirements. Therefore, I put together a pseudo-extension for this. I've finally decided it is time to share it with the world. Since no one but myself has seen it I still consider it beta. At some point I intend to put out an announcement and a bit more formality around its release but was hoping to get some feedback first. So I share it here. For more details please check out the README file. https://github.com/polobo/RoleGraphForPostgreSQL Feedback is much appreciated. Thanks! David J. --0000000000009a38ad06155ef1e0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hey All,

Last year with the revisi= ons to CREATEROLE I decided that having a view that allowed one to more rea= dily see the membership graph of their cluster would be useful.=C2=A0 I ori= ginally tried to write something up for psql but decided that was impractic= al given its requirements.=C2=A0 Therefore, I put together a pseudo-extensi= on for this.=C2=A0 I've finally decided it is time to share it with the= world.=C2=A0 Since no one but myself has seen it I still consider it beta.= =C2=A0 At some point I intend to put out an announcement and a bit more for= mality around its release but was hoping to get some feedback first.=C2=A0 = So I share it here.=C2=A0 For more details please check out the README file= .

<= br>
Feedback is much appreciated.

Thanks!

David J.

--0000000000009a38ad06155ef1e0--