Hi to all, I configured the log rotation of postgresql started in this way:
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start > /var/log/postgresql.log 2>&1" < /dev/null with the log rotate file: /var/log/postgresql.log { compress rotate 5 size=10000k create 0664 postgres postgres daily sharedscripts copytruncate } the problem now is that the postgres server is really stressed and write continuosly on the log file and the file is not truncated!!!!! anyone have any idea?? Ciao Gaetano -- #exclude <windows> #include <CSRSS> printf("\t\t\b\b\b\b\b\b");. printf("\t\t\b\b\b\b\b\b"); ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly