2010/4/19 Đỗ Ngọc Trí Cường
> Dear all,
>
> I've a problem but I search all the help file and can't find the solution.
>
> I want to track all action of a specify role on all or one schema in
> database.
>
> Can you help me?
>
> Thanks a lot and Best Regard,
>
Setup your log_line_prefix and log
On 21/04/2010 8:10 AM, Steve Crawford wrote:
From the docs for log_statement: "Only superusers can change this
setting. "
Argh. Thankyou.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Craig Ringer wrote:
On 20/04/2010 10:33 PM, Scott Marlowe wrote:
psql
show log_statement;
log_statement
---
all
Note however that other sessions won't see the change. Only
connections that come after the change will see it.
Also, as the OP wants to use it for auditing, it's
On 20/04/2010 10:33 PM, Scott Marlowe wrote:
psql
show log_statement;
log_statement
---
all
Note however that other sessions won't see the change. Only
connections that come after the change will see it.
Also, as the OP wants to use it for auditing, it's worth noting that
i
On Tue, Apr 20, 2010 at 8:31 AM, Scott Marlowe wrote:
> On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ wrote:
>> On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
>>> Wouldn't this work:
>>>
>>> alter user smarlowe set log_statement = 'all';
>>
>> IIRC it only works inside the given session
On Tue, Apr 20, 2010 at 6:11 AM, Devrim GÜNDÜZ wrote:
> On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
>> Wouldn't this work:
>>
>> alter user smarlowe set log_statement = 'all';
>
> IIRC it only works inside the given session (so it needs to be run each
> time a query will be executed)
On Tue, 2010-04-20 at 06:03 -0600, Scott Marlowe wrote:
> Wouldn't this work:
>
> alter user smarlowe set log_statement = 'all';
IIRC it only works inside the given session (so it needs to be run each
time a query will be executed)
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certi
2010/4/18 Craig Ringer :
> Đỗ Ngọc Trí Cường wrote:
>> Dear all,
>>
>> I've a problem but I search all the help file and can't find the solution.
>>
>> I want to track all action of a specify role on all or one schema in
>> database.
>>
>> Can you help me?
>
> You can use statement-level logging, t
Yeb Havinga wrote:
> Craig Ringer wrote:
>> Đỗ Ngọc Trí Cường wrote:
>>
>>> Dear all,
>>>
>>> I've a problem but I search all the help file and can't find the
>>> solution.
>>>
>>> I want to track all action of a specify role on all or one schema in
>>> database.
>>>
>>> Can you help me?
>>>
Craig Ringer wrote:
Đỗ Ngọc Trí Cường wrote:
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
You can use statement-level logging, though there are no
Đỗ Ngọc Trí Cường wrote:
> Dear all,
>
> I've a problem but I search all the help file and can't find the solution.
>
> I want to track all action of a specify role on all or one schema in
> database.
>
> Can you help me?
You can use statement-level logging, though there are no facilities in
st
Dear all,
I've a problem but I search all the help file and can't find the solution.
I want to track all action of a specify role on all or one schema in
database.
Can you help me?
Thanks a lot and Best Regard,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
12 matches
Mail list logo
