(2014/01/28 11:07), Peter Geoghegan wrote:
On Mon, Jan 27, 2014 at 6:04 PM, KONDO Mitsumasa
<kondo.mitsum...@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.
No. I don't say root user is superuser. Executing initdb user will be postgres
superuser. But it can change non-superuser after creating database.
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).
I feel the sense of incongruity that is stored database data in text file.
I'd like to hear from other people...
Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
