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.96) (envelope-from ) id 1vgOrx-00BqXs-0w for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jan 2026 15:02:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgOrw-00HQ42-0k for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jan 2026 15:02:40 +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.96) (envelope-from ) id 1vgOrv-00HQ3s-1z for pgsql-admin@lists.postgresql.org; Thu, 15 Jan 2026 15:02:40 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vgOrt-000a3A-0P for pgsql-admin@lists.postgresql.org; Thu, 15 Jan 2026 15:02:38 +0000 Received: by mail-wr1-x435.google.com with SMTP id ffacd0b85a97d-432da746749so487994f8f.0 for ; Thu, 15 Jan 2026 07:02:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768489356; x=1769094156; darn=lists.postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=nXYdqgy0nMDZqHVWPCLoaVnXWbhlg758DkOsjrWgVwE=; b=bY4jCpRqWhzQ8vroYWPsMjD1NKiqznkHQ1pz9L7+UIAZbbXIVDPQDqL+X+69snASSR wb02luRpG2eVvXpvBKp1nx3TKuvlkzc9VASiyX1KDbKozX2+V7EFv6imAKChOlJYKKKn FNabTZDbjNs8HproSOPMabnHBZglUZohEjE5GlifbTp9iVYKHWgDmwzrc7Jy4sm8pVfw Pntc59x8sKL25JUYx8JEyAfhRx7U/xgSI/G2m6TvPLs9gKmn0+U7FzAMYGuo350LYMGz xK91EC9ZAf0kEA9ARKlNbUTofcDCeKTh9Rtg7PXwXmaKiT58N5GG50bekvqcUEy8Uzri 625A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768489356; x=1769094156; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=nXYdqgy0nMDZqHVWPCLoaVnXWbhlg758DkOsjrWgVwE=; b=t3gFg4w+NECMT70QhE5zoOLzEs/Risr/uo6kpZEZtphVx60hCzsp2aZO79gLbjJnv0 pohHT6n5neYo1flwbZP2h7izume5pixdRhBHl5OE8BzeYboqJbIrzYeT4qsSubfXhSdB Bx3yNp9umfadAPgN0ydeI0Pc8BH/yP78kYbdRk7T60NB8PfuF1DerreMTPebZTAE0lCw IAE1WasUi+ByiK3i+uHDhfgMMYXu8wdSqC4IZmfiyK8j9mkBZjHozt5JE8h+n1Wel8Z6 uho2E2czChCTmAKxNVSuqQkOu55DKHd4KnijSdkL/d/fAr1NW7YC2Sn3MlYwJb9Bhk34 fwHw== X-Forwarded-Encrypted: i=1; AJvYcCVWhTXB2UxZZ0MdHIDLl/5fyN2cMXwsEczQv2mgvGnfU+PvEuk2LAFHfRVmOxAdJs59MCmejDFQKNjxYA==@lists.postgresql.org X-Gm-Message-State: AOJu0YwAKHtxJcIDvlzU5vDwBYqY446A3wGJ9PvT3nFExJBXQO6URAll ciIj0BU+irlf6N07V6ddKrF7EF+irUa7PJf91P2+acdhjpwva+sse/eZ X-Gm-Gg: AY/fxX4nZsuXxoTW1N66n7q9eIzMXgvqLHo+I9mjvRgDgx6P87gnIteUEMYFdiiM06J lBxyyFyj9dKrhEIL8lYPzy6P8elYvWKxrAeZnOzKzpwzEIqmrAEzmP4NXiO++IgnJW5UhBTbT3F pTpcCg9Bt+AIYqaNaZeq5fY/oYJmD8XMRZzRzVetsUAMAaUvn2NXRbkS0QJvRy7FJNGglCYp5A/ H98n2aQqGwFjlSFWqcoMQZNg7LT04riAl6lrkpnOZyG2a+3L6fIDsFjbEzYD4ETM/kMwTXVzdKZ TUlDPx6uz0aC5Xnmaqr38Tzq+23vKHOnXG1ipwNO0nWlPO7A6Tr0SlGPzDmDcnanjqoX08P3UDa uNMcKyyU8iUbPdlcr8rTMtFxFk/SpFoyL7LbA31aPGgZZoHhU3PmXJMaerb5S0VzZUa32idSp0M a6fT2M2VAWMC4NaAp/JZNbgWNLxoWn8GExQNyaQU5qEhqFQ9TZ35HcfbpGZHLsukhH14aekhGO X-Received: by 2002:a05:6000:24c7:b0:432:c37c:d83b with SMTP id ffacd0b85a97d-4342c4ffb48mr8235658f8f.20.1768489355660; Thu, 15 Jan 2026 07:02:35 -0800 (PST) Received: from ?IPV6:2a01:e0a:22d:4d0:1ac0:4dff:fe8b:a3c7? ([2a01:e0a:22d:4d0:1ac0:4dff:fe8b:a3c7]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-434af6d9039sm6495649f8f.30.2026.01.15.07.02.35 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 15 Jan 2026 07:02:35 -0800 (PST) Content-Type: multipart/alternative; boundary="------------u0MCAkvCpu0hwbI3SaC36u6M" Message-ID: <2c004899-b0c2-41fd-8d58-2c9f4e7a4a32@gmail.com> Date: Thu, 15 Jan 2026 16:02:34 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Is PgAudit extension database specific? To: Dharin Shah , zaidagilist , "David G. Johnston" Cc: Siraj G , Pgsql-admin References: Content-Language: en-US From: Pierre Forstmann In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------u0MCAkvCpu0hwbI3SaC36u6M Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit I have just tested pgaudit 18 with PostgreSQL 18.1. I have only installed pgaudit in postgres database and I have created 2 other databases db1 and db2. If I run: postgres@alma ~]$ psql db1 psql (18.1) Type "help" for help. db1=# \dx                           List of installed extensions   Name   | Version | Default version |   Schema   |  Description ---------+---------+-----------------+------------+------------------------------  plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language (1 row) db1=# select * from t1;  x --- (0 rows) db1=# \q [postgres@alma ~]$ psql db2 psql (18.1) Type "help" for help. db2=# \dx                           List of installed extensions   Name   | Version | Default version |   Schema   |  Description ---------+---------+-----------------+------------+------------------------------  plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language (1 row) db2=# select * from t2;  x --- (0 rows) db2=# \q [postgres@alma ~]$ I get in PG log: 2026-01-15 15:58:23.044 CET [47325] LOG:  AUDIT: SESSION,1,1,READ,SELECT,,,"SELECT e.extname AS ""Name"", e.extversion AS ""Version"", ae.default_version AS ""Default version"",n.nspname AS ""Schema"", d.description AS ""Description""     FROM pg_catalog.pg_extension e LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname     ORDER BY 1", 2026-01-15 15:58:29.192 CET [47325] LOG:  AUDIT: SESSION,2,1,READ,SELECT,,,select * from t1, 2026-01-15 15:58:39.620 CET [47332] LOG:  AUDIT: SESSION,1,1,READ,SELECT,,,"SELECT e.extname AS ""Name"", e.extversion AS ""Version"", ae.default_version AS ""Default version"",n.nspname AS ""Schema"", d.description AS ""Description""     FROM pg_catalog.pg_extension e LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname     ORDER BY 1", 2026-01-15 15:58:42.416 CET [47332] LOG:  AUDIT: SESSION,2,1,READ,SELECT,,,select * from t2, We can conclude that  installing pgaudit extension works for all databases. It seems also that pgaudit does not log database name (I have not anything pgaudit documentation about database name). Le 06/01/2026 à 18:55, Dharin Shah a écrit : > 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 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 wrote: > > Hello Experts! > > Here is my observation: > > Connected to postgres DB and ran: > CREATE EXTENSION pgaudit; > > Within postgres DB, I ran this: > SELECT*FROMpg_catalog.pg_extension WHEREextname ='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 > --------------u0MCAkvCpu0hwbI3SaC36u6M Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

I have just tested pgaudit 18 with PostgreSQL 18.1.

I have only installed pgaudit in postgres database and I have created 2 other databases db1 and db2.

If I run:

postgres@alma ~]$ psql db1
psql (18.1)
Type "help" for help.

db1=# \dx
                          List of installed extensions
  Name   | Version | Default version |   Schema   |         Description          
---------+---------+-----------------+------------+------------------------------
 plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language
(1 row)

db1=# select * from t1;
 x 
---
(0 rows)

db1=# 
\q
[postgres@alma ~]$ psql db2
psql (18.1)
Type "help" for help.

db2=# \dx
                          List of installed extensions
  Name   | Version | Default version |   Schema   |         Description          
---------+---------+-----------------+------------+------------------------------
 plpgsql | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language
(1 row)

db2=# select * from t2;
 x 
---
(0 rows)

db2=# 
\q
[postgres@alma ~]$ 


I get in PG log:


2026-01-15 15:58:23.044 CET [47325] LOG:  AUDIT: SESSION,1,1,READ,SELECT,,,"SELECT e.extname AS ""Name"", e.extversion AS ""Version"", ae.default_version AS ""Default version"",n.nspname AS ""Schema"", d.description AS ""Description""
    FROM pg_catalog.pg_extension e LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname
    ORDER BY 1",<not logged>
2026-01-15 15:58:29.192 CET [47325] LOG:  AUDIT: SESSION,2,1,READ,SELECT,,,select * from t1,<not logged>
2026-01-15 15:58:39.620 CET [47332] LOG:  AUDIT: SESSION,1,1,READ,SELECT,,,"SELECT e.extname AS ""Name"", e.extversion AS ""Version"", ae.default_version AS ""Default version"",n.nspname AS ""Schema"", d.description AS ""Description""
    FROM pg_catalog.pg_extension e LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace LEFT JOIN pg_catalog.pg_description d ON d.objoid = e.oid AND d.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass LEFT JOIN pg_catalog.pg_available_extensions() ae(name, default_version, comment) ON ae.name = e.extname
    ORDER BY 1",<not logged>
2026-01-15 15:58:42.416 CET [47332] LOG:  AUDIT: SESSION,2,1,READ,SELECT,,,select * from t2,<not logged>


We can conclude that  installing pgaudit extension works for all databases.

It seems also that pgaudit does not log database name (I have not anything pgaudit documentation about database name).



Le 06/01/2026 à 18:55, Dharin Shah a écrit :
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 <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 PM 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 = '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

--------------u0MCAkvCpu0hwbI3SaC36u6M--