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 1nsUIU-0002O9-G0 for pgsql-hackers@arkaria.postgresql.org; Sat, 21 May 2022 18:57:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nsUIT-0004Ck-5J for pgsql-hackers@arkaria.postgresql.org; Sat, 21 May 2022 18:57:53 +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 1nsUIS-0004Cb-Q9 for pgsql-hackers@lists.postgresql.org; Sat, 21 May 2022 18:57:52 +0000 Received: from mail-pj1-x102f.google.com ([2607:f8b0:4864:20::102f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nsUIP-0002hP-3b for pgsql-hackers@postgresql.org; Sat, 21 May 2022 18:57:52 +0000 Received: by mail-pj1-x102f.google.com with SMTP id n10so10627884pjh.5 for ; Sat, 21 May 2022 11:57:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=ibNI5ukE59V/JWCwvoCo499s17rjXAG/MnesBZhVXO4=; b=YA5Vy5pBQxV2ZVUl61vpch3Tk2XkWzJSN7042gZAGVy9SWxLIpG7zc+r9JQ49mT3HJ NskrwpXRV+r3DfR8PKb8W6G9GwPmLfAqeaXB+JMe1QgyVdCbydq+yaD478DyJ/XlvlMS KOvINGIHobOtaw8sHJbY25pyBlJFgsGVp2uKeRE27sBfvV6VA4d5bnVTx0PiK6/FJpYW ljyIDwB0UuZkkMcA1FlSB2PT/ITh4/G/ER8ZDrxep68L91MNS3jZ59kzJLDuskYMWEfL JDAbBKYZtp03Xx5dipx+6l2UX0+otng6nb/9c2k9oLEQSAbXWkdB5VTKjwoTBvfVJWMK 4vlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=ibNI5ukE59V/JWCwvoCo499s17rjXAG/MnesBZhVXO4=; b=eQvUjAweduCMU7G3Nmz09XiX9iHppqX6zYOqFaNBQXAq4IvQGFMyBmY42A5ciVJ462 GWaWLKvPilrXuluM5i7FwS/chl69fes9b4nb974nx7iSF09Mu5W+zDrUb/qwyoCbeSKT uTUo5/AOKTNl3ZhgEwaXt+npDKRmg6Ev0/LfiHDkBuxnFS8qmTay4mKvKQ5SdVXrPYlC b640YOyKpu4HF+x3LaLrEtPxE7k0FO0BKhTYPVdSp3oD16gLo5nSQH5Sw7VexKzhm4mn k8trIm4ormEW7FbRTbum9qFPK+oeV/pKyDXRhz2CGyucmuwM1OSYD8rByFG0a3I87TFR phQA== X-Gm-Message-State: AOAM5336CTG+qLDgjB+qfmfht5bDom0ZHmv4pUVxebqb1o27dfaLoIlf 7hj4zvBZaGJuk/uWCOesYUA= X-Google-Smtp-Source: ABdhPJw6zNUISKM0o4FOVqrhwO8ghutfEFfp38CvUPV9/tXqsQDQ+8ePWJ3UWe1uVtWJP3hD4IpKQw== X-Received: by 2002:a17:903:28c:b0:161:6b8a:dcd4 with SMTP id j12-20020a170903028c00b001616b8adcd4mr15384595plr.120.1653159466445; Sat, 21 May 2022 11:57:46 -0700 (PDT) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id n18-20020a056a00213200b0050dc762816fsm4028761pfj.73.2022.05.21.11.57.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 21 May 2022 11:57:45 -0700 (PDT) Date: Sat, 21 May 2022 11:57:43 -0700 From: Nathan Bossart To: Michael Paquier Cc: Ian Lawrence Barwick , pgsql-hackers Subject: Re: docs: mention "pg_read_all_stats" in "track_activities" description Message-ID: <20220521185743.GA886636@nathanxps13> References: <20220520230837.GB877934@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="jI8keyz6grp/JLjh" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --jI8keyz6grp/JLjh Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, May 21, 2022 at 12:28:58PM +0900, Michael Paquier wrote: > Indeed, it is a good idea to add this information. Will apply and > backpatch accordingly. Sorry, I should've noticed this yesterday. This should probably follow 6198420's example and say "roles with privileges of the pg_read_all_stats role" instead of "members of the pg_read_all_stats role." Also, I think we should mention that this information is visible to roles with privileges of the session user being reported on, too. Patch attached. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com --jI8keyz6grp/JLjh Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="read_all_stats_fix.patch" diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index fe64239ed9..a91145ccf3 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7917,11 +7917,11 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; executing command of each session, along with its identifier and the time when that command began execution. This parameter is on by default. Note that even when enabled, this information is only - visible to superusers, members of the - pg_read_all_stats role and the user owning the - session being reported on, so it should not represent a security risk. - Only superusers and users with the appropriate SET - privilege can change this setting. + visible to superusers, roles with privileges of the + pg_read_all_stats role, and roles with privileges of + the user owning the session being reported on, so it should not + represent a security risk. Only superusers and users with the + appropriate SET privilege can change this setting. --jI8keyz6grp/JLjh--