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 faermini@tin.it
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini@sms.tin.it