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 ? >> >> regds >> Mallah. >> > > > > -- > Achilleas Mantzios >
