Re: pgsql: Keep pg_stat_statements' query texts in a file, not in shared me - Mailing list pgsql-committers

From Peter Geoghegan
Subject Re: pgsql: Keep pg_stat_statements' query texts in a file, not in shared me
Date
Msg-id CAM3SWZT4w1UofAArzvHnMmFA3HLnYMok3gjESDQaUd=U_ZgpTg@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Keep pg_stat_statements' query texts in a file, not in shared me  (KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>)
Responses Re: pgsql: Keep pg_stat_statements' query texts in a file, not in shared me
List pgsql-committers
On Mon, Jan 27, 2014 at 6:04 PM, KONDO Mitsumasa
<kondo.mitsumasa@lab.ntt.co.jp> wrote:
> It is written in documents; "For security reasons, non-superusers are not
> allowed to see the text of queries executed by other users." Is root user
> superuser? And initdb user might change to non-superuser after creating
> database cluster. In japan, database operation user isn't always database
> admin. Because database admin's salary is expensive than system operator's.

initdb will not run as a superuser to begin with. It flatly refuses.

Why is your concern with pg_stat_statements after this patch in particular?

You'll need to serialize the file at least once before seeing it, but
then it's there for good (on old versions, before Magnus got annoyed
that that affected basebackups).
--
Peter Geoghegan


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Keep pg_stat_statements' query texts in a file, not in shared me
Next
From: Tom Lane
Date:
Subject: pgsql: Log a detail message for auth failures due to missing or expired