MIME-Version: 1.0
References: 
 <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
 <CAFS1Kf4ZH0XAcU3H1FCFgy65=tTc+-wnDq=-XunseW30V4KBHw@mail.gmail.com>
In-Reply-To: 
 <CAFS1Kf4ZH0XAcU3H1FCFgy65=tTc+-wnDq=-XunseW30V4KBHw@mail.gmail.com>
From: Dharin Shah <dharinshah95@gmail.com>
Date: Tue, 6 Jan 2026 18:55:07 +0100
Message-ID: 
 <CAOj6k6f53Yag0trVUUHq5vrzREVFkicDpiG2WNjpivHMYANzKg@mail.gmail.com>
Subject: Re: Is PgAudit extension database specific?
To: zaidagilist <zaidagilist@gmail.com>
Cc: Siraj G <tosiraj.g@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000000057180647bbe1be"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOj6k6f53Yag0trVUUHq5vrzREVFkicDpiG2WNjpivHMYANzKg%40mail.gmail.com>
Precedence: bulk

--0000000000000057180647bbe1be
Content-Type: multipart/alternative; boundary="0000000000000057170647bbe1bc"

--0000000000000057170647bbe1bc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello,

This is standard for all pg extensions as mentioned above.

Just adding a minor doc patch to add clarification in the doc.

Thanks,
Dharin

On Tue, Jan 6, 2026 at 6:30=E2=80=AFPM zaidagilist <zaidagilist@gmail.com> =
wrote:

> Hello Siraj,
>
> pgAudit is a coupled component build for a specific PG version, for each
> PG version you are required to install separately. Same behavior as other
> PG based extensions.
>
> Regards,
> Zaid
>
> On Tue, Jan 6, 2026 at 10:19=E2=80=AFPM Siraj G <tosiraj.g@gmail.com> wro=
te:
>
>> Hello Experts!
>>
>> Here is my observation:
>>
>> Connected to postgres DB and ran:
>> CREATE EXTENSION pgaudit;
>>
>> Within postgres DB, I ran this:
>> SELECT * FROM pg_catalog.pg_extension WHERE extname =3D 'pgaudit';
>>
>> It does return a row.
>>
>> I changed the DB and ran the same SQL, but it does not return any thing.
>>
>> The PostgreSQL instance is a GCP cloud SQL running with postgres V14.19.
>>
>> Would you help me understand this, please.
>>
>> Regards
>> Siraj
>>
>>

--0000000000000057170647bbe1bc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,=C2=A0<div><br></div><div>This is standard for all p=
g extensions=C2=A0as mentioned above.<br><br>Just adding a minor doc patch =
to add clarification in the doc.<br><br>Thanks,<br>Dharin</div></div><br><d=
iv class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Tue, Jan 6, 2026 at 6:30=E2=80=AFPM zaidagilist &lt;<a href=3D=
"mailto:zaidagilist@gmail.com">zaidagilist@gmail.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello =
Siraj,<div><br></div><div>pgAudit is a coupled component build for a specif=
ic PG version, for each PG version you are required to install separately. =
Same behavior as other PG based extensions.</div><div><br></div><div>Regard=
s,</div><div>Zaid</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr=
" class=3D"gmail_attr">On Tue, Jan 6, 2026 at 10:19=E2=80=AFPM Siraj G &lt;=
<a href=3D"mailto:tosiraj.g@gmail.com" target=3D"_blank">tosiraj.g@gmail.co=
m</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"ltr">Hello Experts!<div><br></div><div>Here is my observation:=
</div><div><br></div><div>Connected to postgres DB and ran:</div><div>CREAT=
E EXTENSION pgaudit;</div><div><br></div><div>Within postgres DB, I ran thi=
s:</div><div><span style=3D"color:rgb(33,150,243)">SELECT<span style=3D"dis=
play:none"></span></span> <span style=3D"display:none"></span><span style=
=3D"color:rgb(33,150,243)">*<span style=3D"display:none"></span></span> <sp=
an style=3D"display:none"></span><span style=3D"color:rgb(33,150,243)">FROM=
<span style=3D"display:none"></span></span> pg_catalog.pg_extension <span s=
tyle=3D"display:none"></span><span style=3D"color:rgb(33,150,243)">WHERE<sp=
an style=3D"display:none"></span></span> extname <span style=3D"display:non=
e"></span><span style=3D"color:rgb(33,150,243)">=3D<span style=3D"display:n=
one"></span></span> &#39;pgaudit&#39;;</div><div><br></div><div>It does ret=
urn a row.</div><div><br></div><div>I changed the DB and ran the same SQL, =
but it does not return any thing.</div><div><br></div><div>The PostgreSQL i=
nstance is a GCP cloud SQL running with postgres V14.19.</div><div><br></di=
v><div>Would you help me understand this, please.</div><div><br></div><div>=
Regards</div><div>Siraj</div><div><br></div></div>
</blockquote></div>
</blockquote></div>

--0000000000000057170647bbe1bc--

--0000000000000057180647bbe1be
Content-Type: application/octet-stream;
	name="v1-0001-doc-clarify-pg_extension-is-per-database-not-cluster.patch"
Content-Disposition: attachment;
	filename="v1-0001-doc-clarify-pg_extension-is-per-database-not-cluster.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mk2vw5z50>
X-Attachment-Id: f_mk2vw5z50

RnJvbSA5ZjU4NmNiMDM5YmNhYzQwODYyZGIyMjJhMTZhODU1MGVjM2NhZTQyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBEaGFyaW4gU2hhaCA8ODYxNjEzMCtEaGFyaW4tc2hhaEB1c2Vy
cy5ub3JlcGx5LmdpdGh1Yi5jb20+CkRhdGU6IFR1ZSwgNiBKYW4gMjAyNiAxODo0NTo0NCArMDEw
MApTdWJqZWN0OiBbUEFUQ0hdIGRvYzogY2xhcmlmeSBwZ19leHRlbnNpb24gaXMgcGVyLWRhdGFi
YXNlLCBub3QgY2x1c3Rlci13aWRlCgotLS0KIGRvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sIHwg
NyArKysrKysrCiAxIGZpbGUgY2hhbmdlZCwgNyBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0IGEv
ZG9jL3NyYy9zZ21sL2NhdGFsb2dzLnNnbWwgYi9kb2Mvc3JjL3NnbWwvY2F0YWxvZ3Muc2dtbApp
bmRleCAyZmM2MzQ0Mjk4MC4uZmExM2Y5YTlkNWMgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9j
YXRhbG9ncy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sCkBAIC0zOTY0LDYg
KzM5NjQsMTMgQEAgU0NSQU0tU0hBLTI1NiQ8cmVwbGFjZWFibGU+Jmx0O2l0ZXJhdGlvbiBjb3Vu
dCZndDs8L3JlcGxhY2VhYmxlPjo8cmVwbGFjZWFibGU+JmwKICAgIGZvciBkZXRhaWxzIGFib3V0
IGV4dGVuc2lvbnMuCiAgIDwvcGFyYT4KIAorICA8cGFyYT4KKyAgIExpa2UgbW9zdCBzeXN0ZW0g
Y2F0YWxvZ3MsIDxzdHJ1Y3RuYW1lPnBnX2V4dGVuc2lvbjwvc3RydWN0bmFtZT4gaXMgbm90Cisg
ICBzaGFyZWQgYWNyb3NzIGRhdGFiYXNlczogdGhlcmUgaXMgb25lIGNvcHkgb2YgPHN0cnVjdG5h
bWU+cGdfZXh0ZW5zaW9uPC9zdHJ1Y3RuYW1lPgorICAgcGVyIGRhdGFiYXNlLCBub3Qgb25lIHBl
ciBjbHVzdGVyLiAgQ29uc2VxdWVudGx5LCBleHRlbnNpb25zIG11c3QgYmUKKyAgIGluc3RhbGxl
ZCBzZXBhcmF0ZWx5IGluIGVhY2ggZGF0YWJhc2Ugd2hlcmUgdGhleSBhcmUgbmVlZGVkLgorICA8
L3BhcmE+CisKICAgPHRhYmxlPgogICAgPHRpdGxlPjxzdHJ1Y3RuYW1lPnBnX2V4dGVuc2lvbjwv
c3RydWN0bmFtZT4gQ29sdW1uczwvdGl0bGU+CiAgICA8dGdyb3VwIGNvbHM9IjEiPgotLSAKMi4z
OS4zIChBcHBsZSBHaXQtMTQ2KQoK
--0000000000000057180647bbe1be--