On 8 May 2001, at 7:13, Raymond Chui wrote: > What is the $PGDATA/data/pg_log file use for? > Is it a logical log file file? I see that file grow very big. > Can I do `cat /dev/null > $PGDATA/data/pg_log` > reduce it to zero size once a while? Or is there other DON'T!!!!! That file is the transaction log... it is VITAL for the consistency of the DB. Consider that as a part of the DB itself, together with other files under /data, and let postgres handle it with its means... /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Fabrizio Ermini Alternate E-mail: C.so Umberto, 7 [EMAIL PROTECTED] loc. Meleto Valdarno Mail on GSM: (keep it short!) 52020 Cavriglia (AR) [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]