MIME-Version: 1.0
References: 
 <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
In-Reply-To: 
 <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 6 Jan 2026 10:26:59 -0700
Message-ID: 
 <CAKFQuwYasZoFC0mYyLc6THekOTXpfO-+SKcAftw7OYpjCKrWaA@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="000000000000de9a3e0647bb7dc2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwYasZoFC0mYyLc6THekOTXpfO-%2BSKcAftw7OYpjCKrWaA%40mail.gmail.com>
Precedence: bulk

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

On Tue, Jan 6, 2026 at 10:19=E2=80=AFAM Siraj G <tosiraj.g@gmail.com> wrote=
:

> Connected to postgres DB and ran:
> CREATE EXTENSION pgaudit;
>
>
"create extension" always executes strictly within the database you are
connected to.  It may have effects that go beyond that database, depending
on what the extension does, but absent documentation to the contrary assume
that an extension only operates within the database it was installed into.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Jan 6, 2026 at 10:19=E2=80=AFAM Siraj G &lt;<a hre=
f=3D"mailto:tosiraj.g@gmail.com">tosiraj.g@gmail.com</a>&gt; wrote:</span><=
/div></div><div class=3D"gmail_quote gmail_quote_container"><blockquote cla=
ss=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"><div>Connected to postg=
res DB and ran:</div><div>CREATE EXTENSION pgaudit;</div><div><br></div></d=
iv></blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-f=
amily:arial,helvetica,sans-serif">&quot;create extension&quot; always execu=
tes strictly within the database you are connected to.=C2=A0 It may have ef=
fects that go beyond that database, depending on what the extension does, b=
ut absent documentation to the contrary assume that an extension only opera=
tes within the database it was installed into.</div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><br></div></div></div>

--000000000000de9a3e0647bb7dc2--