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