| From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> |
| Subject: | Re: conditional logging based on client |
| Date: | 2008-07-22 12:24:44 |
| Message-ID: | 200807221524.45181.achill@matrix.gatewaynet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Στις 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dx k9 | 2008-07-22 13:39:57 | shared_buffers and shmmax |
| Previous Message | Rajesh Kumar Mallah | 2008-07-22 12:17:42 | conditional logging based on client |