Gaetano Mendola wrote:
><mallah@trade-india.com> wrote:
>
>
>>>hi,
>>>
>>>Sir, i follow your procedure of Postgres installation (version 7.1.3)
>>>on linux 2.4.7-10.
>>>
>>>I want to know how to enable syslog and mention the log information
>>>will store in /var/postgreslog directory path..
>>>
>>>
>>not sure abt 7.1.3 , but in 7.3.3 u can do the following.
>>
>>In postgresql.conf file
>>
>>#
>># Syslog
>>#
>>syslog = 2 # range 0-2
>>syslog_facility = 'LOCAL0'
>>syslog_ident = 'postgres'
>>
>>
>>in /etc/syslog.conf file
>>local0.* /var/postgreslog
>>
>>
>
>I remember you also that you can turn off the syslog to fsync each
>log to the file putting a "-" before the filename:
>
>local0.* -/var/postgreslog
>
>this should increase the log performances
>
>
>
But doesnt this mean that you could loose log data in case of a power
failure?