Στις 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 > > regds > Mallah. > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
