MIME-Version: 1.0
References: 
 <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
In-Reply-To: 
 <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
From: zaidagilist <zaidagilist@gmail.com>
Date: Tue, 6 Jan 2026 22:29:39 +0500
Message-ID: 
 <CAFS1Kf4ZH0XAcU3H1FCFgy65=tTc+-wnDq=-XunseW30V4KBHw@mail.gmail.com>
Subject: Re: Is PgAudit extension database specific?
To: Siraj G <tosiraj.g@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f2425b0647bb857e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFS1Kf4ZH0XAcU3H1FCFgy65%3DtTc%2B-wnDq%3D-XunseW30V4KBHw%40mail.gmail.com>
Precedence: bulk

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

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> wrote=
:

> 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
>
>

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

<div dir=3D"ltr">Hello Siraj,<div><br></div><div>pgAudit is a coupled compo=
nent build for a specific PG version, for each PG version you are required =
to install separately. Same behavior as other PG based extensions.</div><di=
v><br></div><div>Regards,</div><div>Zaid</div></div><br><div class=3D"gmail=
_quote gmail_quote_container"><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@gm=
ail.com">tosiraj.g@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-=
left-style:solid;border-left-color: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>CREATE EXTE=
NSION pgaudit;</div><div><br></div><div>Within postgres DB, I ran this:</di=
v><div><span style=3D"color:rgb(33,150,243)">SELECT<span style=3D"display:n=
one"></span></span> <span style=3D"display:none"></span><span style=3D"colo=
r:rgb(33,150,243)">*<span style=3D"display:none"></span></span> <span style=
=3D"display:none"></span><span style=3D"color:rgb(33,150,243)">FROM<span st=
yle=3D"display:none"></span></span> pg_catalog.pg_extension <span style=3D"=
display:none"></span><span style=3D"color:rgb(33,150,243)">WHERE<span style=
=3D"display:none"></span></span> extname <span style=3D"display:none"></spa=
n><span style=3D"color:rgb(33,150,243)">=3D<span style=3D"display:none"></s=
pan></span> &#39;pgaudit&#39;;</div><div><br></div><div>It does return a ro=
w.</div><div><br></div><div>I changed the DB and ran the same SQL, but it d=
oes not return any thing.</div><div><br></div><div>The PostgreSQL instance =
is a GCP cloud SQL running with postgres V14.19.</div><div><br></div><div>W=
ould you help me understand this, please.</div><div><br></div><div>Regards<=
/div><div>Siraj</div><div><br></div></div>
</blockquote></div>

--000000000000f2425b0647bb857e--