"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> 2008/7/22 Rajesh Kumar Mallah <[EMAIL PROTECTED]>:
>> any hit on performance is not desired.
>> is it possible to alter logging behaviour just for the
>> psql session ?
> Set log_statement='ddl' in your postgresql.conf and pgsql will log all
> ddl that
2008/7/22 Rajesh Kumar Mallah <[EMAIL PROTECTED]>:
> On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
> <[EMAIL PROTECTED]> wrote:
>> Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
>>> Hi,
>>>
>>> We want to log all SQLs that has been executed by using psql client.
>>> we do
Rajesh Kumar Mallah wrote:
On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
The original objective is that we should be able to know what all
hand made SQLs have been executed in past (which can date back
as long as 1 year even)
You have to adjust log_statement in your postgresql.conf ho
On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
<[EMAIL PROTECTED]> wrote:
> Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
>> Hi,
>>
>> We want to log all SQLs that has been executed by using psql client.
>> we do not want to use .psql_history as it is distributed and may b
Achilleas Mantzios wrote:
Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah
ÎγÏ�αψε:
Hi,
We want to log all SQLs that has been executed by using psql
client. we do not want to use .psql_history as it is distributed
and may be deleted by users .
The original objective is tha
Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
> Hi,
>
> We want to log all SQLs that has been executed by using psql client.
> we do not want to use .psql_history as it is distributed and may be
> deleted by users .
>
> The original objective is that we should be able to know
Hi,
We want to log all SQLs that has been executed by using psql client.
we do not want to use .psql_history as it is distributed and may be
deleted by users .
The original objective is that we should be able to know what all hand made
SQLs have been executed in past (which can date back as lon