<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
Regards
Gaetano Mendola