public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dharin Shah <[email protected]>
To: zaidagilist <[email protected]>
Cc: Siraj G <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Is PgAudit extension database specific?
Date: Tue, 6 Jan 2026 18:55:07 +0100
Message-ID: <CAOj6k6f53Yag0trVUUHq5vrzREVFkicDpiG2WNjpivHMYANzKg@mail.gmail.com> (raw)
In-Reply-To: <CAFS1Kf4ZH0XAcU3H1FCFgy65=tTc+-wnDq=-XunseW30V4KBHw@mail.gmail.com>
References: <CAC5iy63sMzJ9j_WBxzjdTjp7y0F_hRuA-=Fjfyy7RFbqdqA16A@mail.gmail.com>
	<CAFS1Kf4ZH0XAcU3H1FCFgy65=tTc+-wnDq=-XunseW30V4KBHw@mail.gmail.com>

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 PM zaidagilist <[email protected]> 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 PM Siraj G <[email protected]> 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 = '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
>>
>>


Attachments:

  [application/octet-stream] v1-0001-doc-clarify-pg_extension-is-per-database-not-cluster.patch (1.1K, 3-v1-0001-doc-clarify-pg_extension-is-per-database-not-cluster.patch)
  download | inline diff:
From 9f586cb039bcac40862db222a16a8550ec3cae42 Mon Sep 17 00:00:00 2001
From: Dharin Shah <[email protected]>
Date: Tue, 6 Jan 2026 18:45:44 +0100
Subject: [PATCH] doc: clarify pg_extension is per-database, not cluster-wide

---
 doc/src/sgml/catalogs.sgml | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index 2fc63442980..fa13f9a9d5c 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -3964,6 +3964,13 @@ SCRAM-SHA-256$<replaceable>&lt;iteration count&gt;</replaceable>:<replaceable>&l
    for details about extensions.
   </para>
 
+  <para>
+   Like most system catalogs, <structname>pg_extension</structname> is not
+   shared across databases: there is one copy of <structname>pg_extension</structname>
+   per database, not one per cluster.  Consequently, extensions must be
+   installed separately in each database where they are needed.
+  </para>
+
   <table>
    <title><structname>pg_extension</structname> Columns</title>
    <tgroup cols="1">
-- 
2.39.3 (Apple Git-146)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Is PgAudit extension database specific?
  In-Reply-To: <CAOj6k6f53Yag0trVUUHq5vrzREVFkicDpiG2WNjpivHMYANzKg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox