From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | oleg yusim <olegyusim(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Loggingt psql meta-commands |
Date: | 2015-12-10 18:13:25 |
Message-ID: | 5669C0C5.7000302@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 12/10/2015 09:58 AM, oleg yusim wrote:
> Greetings!
>
> I'm new to PostgreSQL, working on it from the point of view of Cyber
> Security assessment. In regards to the here is my question:
>
> Is it a way to enable logging for psql prompt meta-commands, such as
> \du, \dp, \z, etc?
aklaver(at)killi:~> psql -d test -E
psql (9.4.4)
Type "help" for help.
aklaver(at)test=> \du
********* QUERY **********
SELECT r.rolname, r.rolsuper, r.rolinherit,
r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
r.rolconnlimit, r.rolvaliduntil,
ARRAY(SELECT b.rolname
FROM pg_catalog.pg_auth_members m
JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
WHERE m.member = r.oid) as memberof
, r.rolreplication
FROM pg_catalog.pg_roles r
ORDER BY 1;
**************************
postgresql.conf
log_statement = 'all'
aklaver-2015-12-10 10:12:45.177 PST-0LOG: statement: SELECT r.rolname,
r.rolsuper, r.rolinherit,
r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
r.rolconnlimit, r.rolvaliduntil,
ARRAY(SELECT b.rolname
FROM pg_catalog.pg_auth_members m
JOIN pg_catalog.pg_roles b ON (m.roleid = b.oid)
WHERE m.member = r.oid) as memberof
, r.rolreplication
FROM pg_catalog.pg_roles r
ORDER BY 1;
>
> Thanks,
>
> Oleg
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2015-12-10 18:14:20 | Re: Loggingt psql meta-commands |
Previous Message | oleg yusim | 2015-12-10 17:58:02 | Loggingt psql meta-commands |