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.94.2) (envelope-from ) id 1uzRT4-003WP2-F9 for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2025 03:07:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uzRT2-003YM6-VY for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2025 03:07:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uzRT2-003YKh-Il for pgsql-general@lists.postgresql.org; Fri, 19 Sep 2025 03:07:24 +0000 Received: from mail-ot1-x32a.google.com ([2607:f8b0:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uzRSy-001cDp-2W for pgsql-general@lists.postgresql.org; Fri, 19 Sep 2025 03:07:24 +0000 Received: by mail-ot1-x32a.google.com with SMTP id 46e09a7af769-74c1251df00so911612a34.0 for ; Thu, 18 Sep 2025 20:07:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758251240; x=1758856040; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=am693n7Hl6Y+X9NpUJRyEWRq5y/LuNT7TStnbKiPkk4=; b=nO5jQpyeA37QsMPF30SZNvOIMQhU/PsnhXbsH5TflANZRz9Ej42fv1NY7d5Tw1BCkl qRMGfTHBR4UsCB2veLBFWxtO5QtKTQRJ66qqq77quwq1pcE121p1hIrE5VtWSg7CWGXP CfGAfJgglV3R/OKDEdE0OCVibgASQ/tmm2pydDQcJ4sIog5BrUHZDgk7FDUnY4PgGvDh Xg0ViAME28Oi9aVYMwXPQBT55WmF6giDstK/145GlQ2GtqFnfcpcd+DaqKuqXvKz2CQ8 oq2paqoIAWVla+jkDHAvfXzXSeDp6Bq2QA3t8B5TLLAe/r3tA3jquKgeLn6aMAouLZFS uopw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758251240; x=1758856040; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=am693n7Hl6Y+X9NpUJRyEWRq5y/LuNT7TStnbKiPkk4=; b=W0ryVBmWC6MjAtDn/50x6UtPC77ex8IK1q1eBJlGBZa384fdgU9gbqLYPrQq8sya95 aPLb/wZfzklGRy4lLrESV6ZGUdDszwVDPJBfZGy/xJa+64fxOdN5c5BjYwvPrYUvrJdK p+4hr8KrIgEaNoPNEpbPxt7lu2Ou5u5cnbWr5CoKM7gmRYZSWzvDdTnUu+RG73rEGTGF UH1VmcbLcdETxpXRyJVmEqgWJN67U5fuWEoXgu7pGQeSxxs/ox3m+rdmZ+gnScJfEPUk SPhIT/VBB4tNIqp9I0kclzzBAWwjX/4P5zvJansofNJEobhMV/kxy2mqi/yIxXAAUt2b SBJg== X-Gm-Message-State: AOJu0Yx36Xeuqm5REPOvxM+QSmrhpaY9ImJBqDfbQM///wcvWyydGpvT bdFq5zGtuuYn7EIx8t+xigOyNcDK7ZdVWd+Fic5CnrCU4eZhKiF/pHXpkNiQ8HO2ZrxdVlfUJz7 /Bug+UEJQv4p5Q+6YbBfbXAA6BtYIgjU= X-Gm-Gg: ASbGnctO4K9CPmWph6VEFgNtWGeCwNN3PqkNauSTuY762nrg/ibZdNS1ZJunEf2ONgl grP1ISJBh+MkVs5ZFZqceJgcFPrJv7C/6goBwuzv3EAh9QXGAW2KjMAdAEe42rjSvLTTlvGwx3d zTrXf9XlKbZwiirYS6wN1UmPSPYwXWruyGQa+N6tLSn4khkNLJImDedCdTESiCkXiLW1hG598PO F2nXg== X-Google-Smtp-Source: AGHT+IF4V0GY9jOeVvKgdIJhx5iiWWVe3kpazaPnp3eCMAynP5dPnwK4tR67cYRiCdczjdRP3JKECBoFSya6JpeLqbI= X-Received: by 2002:a05:6808:6505:b0:438:3d81:b257 with SMTP id 5614622812f47-43d6c2a9b7dmr651270b6e.40.1758251240054; Thu, 18 Sep 2025 20:07:20 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:34ce:10b0:5df:b5f6:b71 with HTTP; Thu, 18 Sep 2025 20:07:19 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Thu, 18 Sep 2025 20:07:19 -0700 X-Gm-Features: AS18NWCgR3nM3PEjnvx1g289ZkoUiuzN8ctiiNHc8aih28-Z7lahVWeusmjFpoo Message-ID: Subject: Re: PostgreSQL Account and Object Timestamp Logging To: =?UTF-8?B?5by15a6455GL?= Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000096e578063f1ec480" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000096e578063f1ec480 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, September 18, 2025, =E5=BC=B5=E5=AE=B8=E7=91=8B wrote: > > > I would like to ask if there are any built-in features or extensions in > open-source PostgreSQL=E2=80=94aside from the AUDIT mechanisms=E2=80=94th= at allow us to > query or log the creation time of user accounts and database objects. > > That information is not captured/retained by a PostgreSQL cluster. See many previous discussions from the mailing list archives. David J. --00000000000096e578063f1ec480 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, September 18, 2025, =E5=BC=B5=E5=AE=B8=E7=91=8B <kenny020307@gmail.com> wrote:

I would like to ask if there are any built-= in features or extensions in open-source PostgreSQL=E2=80=94aside from the = AUDIT mechanisms=E2=80=94that allow us to query or log the creation time of= user accounts and database objects.

=
That information is not captured/retained by a PostgreSQL cl= uster.=C2=A0 See many previous discussions from the mailing list archives.<= /div>

David J.

--00000000000096e578063f1ec480--