Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzCFk-0007I1-8k for pgsql-admin@arkaria.postgresql.org; Mon, 20 Dec 2021 06:34:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzCFi-00039k-9V for pgsql-admin@arkaria.postgresql.org; Mon, 20 Dec 2021 06:34:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzCFh-00039b-U5 for pgsql-admin@lists.postgresql.org; Mon, 20 Dec 2021 06:34:29 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mzCFf-0000Wq-3F for pgsql-admin@lists.postgresql.org; Mon, 20 Dec 2021 06:34:28 +0000 Received: by mail-wr1-x435.google.com with SMTP id e5so17884600wrc.5 for ; Sun, 19 Dec 2021 22:34:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=rIM2FCIQmiuZsSiXItOg24mzGlGqXC5pJi6T6qYlF2M=; b=m0Mp3ag7djbk8sTtmLANOOY+42EQr5KPNhInOxewOqVnsO3BeUoZwfpYJAHtGHBsbm 43bHmMEUrkrPEKcOoDFDV3FRFrARmiS3tNLwFJ8PW0Ewb+tpRVJBzwKssMUxj5/3YmDl CbDJuHB+fsE8II1BmxcY0ZQWnD40rNOLlM2HLFzrUdbu4G0zuVh2yy5IXx15k1VxNB3n esEcGLpyNS4l8yo7LIe8eFt36FiZGDCxzx3xC4Zqump5ny+WQgmNfc0fZUfdAYVgC2D6 PIxec/pdIirnQd4pnenitKDBDlJE781oNWlza3b8Y1MyMVYYnGwj1y+d6qWYFrmQKwA0 yjdQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=rIM2FCIQmiuZsSiXItOg24mzGlGqXC5pJi6T6qYlF2M=; b=korjg2/6uMYikl7Xy91h95oyAF/AGKNlAKTy8PEH4NbQrcOo1RIFtLACo0gAXimyaH 22HZoN2dtdqtSd1xCpALUcuvaR5peSIiMrWhFTcZdZz9IgQRfVNxsK5HLZXmkplV6PIx poqhKgvrhsR+NcktMbi/Gx25wsuNJnrjpzm9G61gX7TP3D1GLkp5J1Ew34QioO5yjMns 9EBeTtkVv8aiV+oOwUCvl58ukygFw+/IA5SLyz8kqN/xaKyr4QcrJoW1WYSNPCI55Uir CATQgxM80lFWDsgIrb80S4yibedhd/GD8JVP1CnMuLZXPEOPUBl7KEV7lcBKEq/ZWmTf Yitw== X-Gm-Message-State: AOAM531HANetsOn5H63YWpwt2X59AUW3MwyJCi0dEF8+viczGzYg3FWU gIOK/IVJsWy9h5F6GT93nXdzvwiznO9HhJW+zWmuOydw X-Google-Smtp-Source: ABdhPJxMrmZHBkD4XvmtOpGuEOriB5hhYNkryR35uz9T3fClHyZ78kEzmSOHOVXt0qnnLNjoaay5apRmYBm9fQ20kUA= X-Received: by 2002:a05:6000:1867:: with SMTP id d7mr11761140wri.21.1639982064849; Sun, 19 Dec 2021 22:34:24 -0800 (PST) MIME-Version: 1.0 From: Daulat Date: Mon, 20 Dec 2021 12:04:13 +0530 Message-ID: Subject: How to Log DBA actions To: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000069d68405d38e141c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000069d68405d38e141c Content-Type: text/plain; charset="UTF-8" Hi Team, I want to log DBA actions in Postgres. Can you please suggest how I can achieve it. Will pg_audit and log_min_duration_statements help on it? Thanks, --00000000000069d68405d38e141c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Team,

I want to log DBA actions = in Postgres. Can you please suggest how I can achieve=C2=A0it.
Wi= ll pg_audit and log_min_duration_statements help on it?

Thanks,


--00000000000069d68405d38e141c--