Dear All, I facing problem in my log rotation for postgres, it is not rotation properly. I am using syslog-ng package for loging. My logs for postgres looks like this, -rw-r--r-- 1 root root 10M Feb 28 23:24 postgres.log.20 -rw-r--r-- 1 root root 0 Feb 28 20:16 postgres.log.21 -rw-r--r-- 1 root root 10M Feb 28 20:15 postgres.log.22 -rw-r--r-- 1 root root 0 Feb 28 17:04 postgres.log.23 -rw-r--r-- 1 root root 10M Feb 28 17:03 postgres.log.24 -rw-r--r-- 1 root root 0 Feb 28 13:52 postgres.log.25 -rw-r--r-- 1 root root 10M Feb 28 13:51 postgres.log.26 -rw-r--r-- 1 root root 0 Feb 28 10:56 postgres.log.27 -rw-r--r-- 1 root root 10M Feb 28 10:55 postgres.log.28 -rw-r--r-- 1 root root 0 Feb 28 08:40 postgres.log.29 -rw-r--r-- 1 root root 0 Mar 2 00:12 postgres.log.3 That's after rotation it generates two files one with 0MB size and another with is of 10MB, so, why it is generating 0MB size log files?? Does it supports syslogng package for loging? If yes then what is the difference is its configuration from normal syslog package. Any help appreciated. -jack __________________________________ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
