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 1uzWFp-004RGu-1a for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2025 08:14:05 +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 1uzWFn-005Jpe-O0 for pgsql-general@arkaria.postgresql.org; Fri, 19 Sep 2025 08:14:03 +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 1uzWFn-005JnL-AH for pgsql-general@lists.postgresql.org; Fri, 19 Sep 2025 08:14:03 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uzWFj-001fGJ-1F for pgsql-general@lists.postgresql.org; Fri, 19 Sep 2025 08:14:03 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-30cce50dfb4so1272998fac.0 for ; Fri, 19 Sep 2025 01:14:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758269639; x=1758874439; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dMqxviKpmM3ZQBP8a+OXLID1NNXE81oc+jBWwjv9ZVM=; b=iCJgCRAIDqlLHbPRKAkk6Z95oHOIJUGAs+jIKXanpCD3J0pLWuFE0KKHLASRHjVg0J kZIoTaK2O5+OvjU1DyvT57cK0MiFO5Dq5dsVMEyLn176e3w1Rabm2CSy2Lv1VhRj+6Nn HYmvocvQl//71iOD/YKQBeD5qIW/I3LCD5DfgmVkLcOK+uR/oA0nG3kBuXvYcay1zoG3 0ukLK5k/Jn/itoe7T9NpCOZwkAoFn9MTdFtoDJ9VFGU2YGF1rq/71lVe3NItQ/tgGZAX enHDzGm7ClJKoJNKHw2CwRwqVIkGqVqyNjUetFL+/SRnmrWzMdd+Ko4zUxKYyxDjzE3D yqLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758269639; x=1758874439; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=dMqxviKpmM3ZQBP8a+OXLID1NNXE81oc+jBWwjv9ZVM=; b=R4g3oAhEL4LeYWLY1oVjSFJlABvegfKwYMO2i+lZBVQtX93ojdlp8xuw56zm/sM0Gk A0XOxBKlF4tZn7Lti2W4cbr1rQwdWeHHA57KpirRv0qRe+BxCUSHw6gBwLXdekAe81Pf e/DJr13XyaxAmFYXCwzAk+dPTEnuDxlA7c3A/UfHCFP8NAwL0+FLw2JuEeYIzs6PijDn tzZspmja5ryBR02O+FQG0J03Nyij4DvLkCk/pr7xBuYZEXp53rmOO/wYZnxsVCMCIRio yTHBAume2RFjPFc36zRSrDyqGKTr6VtcaCb9iNnVEV2BPTi39l0fe0tKujDfH4nTq5Al SLdg== X-Gm-Message-State: AOJu0YxkWtR4lDHNnE4o0O1FpWgjfY4j8Jcw5B2J7Ji38QCHpdXWFbRW H7QBhGjTGDbk0k7uKXtiVkj37zPcYJP0KZCmjpsjYJj6yiRa8esuqNTpwaUHs5Rg0fZIQhssgGj oWEwY+pmrdELkhRaO7Ss/7FLQDEIny/Q= X-Gm-Gg: ASbGncsIuZhwTAEueFGtJbG+G2s48N0v1/CLL4lJKkD+NfbeFwJ2JBUw7BxNW7DgoV1 Omql5DRky8KILNnM/NJdwj2fyBiHxaMliFl1CSpJkF8uUIY75ig1YqUmA7nnZrrWma7oectrY3t 5VuqnZpVR09j7emRtftfHCVZXBWanyCenWAXylVzbXxm0T5Qr5Iq/LIbG5CWYJ2a2WivVy0h5q7 ypAnlGBHg== X-Google-Smtp-Source: AGHT+IGJZz4BKBf9JivZbqMzQrB/7pblgsSSDbVczgQsCnbnBkaMMLUGYwzmIjXJC/FkMVhbpT8s61pF02bUGLvDGL4= X-Received: by 2002:a05:6870:b69e:b0:31d:6d6f:f3a0 with SMTP id 586e51a60fabf-33bb3ff5f01mr1269595fac.20.1758269638955; Fri, 19 Sep 2025 01:13:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dominique Devienne Date: Fri, 19 Sep 2025 10:13:47 +0200 X-Gm-Features: AS18NWBOvNxMmD-rDiHUL9jTZVpS-hoVgVfbrb5VQ0lRblEGMhZrw8N4F5DIU4A Message-ID: Subject: Re: PostgreSQL Account and Object Timestamp Logging To: =?UTF-8?B?5by15a6455GL?= Cc: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 19, 2025 at 4:56=E2=80=AFAM =E5=BC=B5=E5=AE=B8=E7=91=8B wrote: > *log* the creation time of user accounts and database objects. Yes, indirectly, via event triggers: https://www.postgresql.org/docs/current/event-trigger-matrix.html But that's specific to a DB, does [NOT fire for CREATE USER/ROLE][1], only some objects, and unfortunately, must be SUPERUSER to install it, DB OWNER is not enough (pity...). [1]: https://www.postgresql.org/docs/current/event-trigger-matrix.html