Re: [ADMIN] conditional logging based on client

2008-07-23 Thread Tom Lane
"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

Re: [ADMIN] conditional logging based on client

2008-07-23 Thread Scott Marlowe
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

Re: [ADMIN] conditional logging based on client

2008-07-23 Thread Shane Ambler
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

Re: [ADMIN] conditional logging based on client

2008-07-22 Thread Rajesh Kumar Mallah
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

Re: [ADMIN] conditional logging based on client

2008-07-22 Thread Shane Ambler
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

Re: [ADMIN] conditional logging based on client

2008-07-22 Thread Achilleas Mantzios
Στις 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

[ADMIN] conditional logging based on client

2008-07-22 Thread 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 what all hand made SQLs have been executed in past (which can date back as lon