2008/7/22 Rajesh Kumar Mallah <mallah.rajesh@xxxxxxxxx>: > On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios > <achill@xxxxxxxxxxxxxxxxxxxxx> 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 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 >> however you will have to bear in mind the performance implications of this. >> Normal production sites dont do this. >> You can enable/disable this kind of logging any time by killing -HUP > > thanks for reply. > 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 hits the database. It won't log other stuff, just the ddl.
