Gaetano Mendola wrote:
<[EMAIL PROTECTED]> 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?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
