Thread: Whait is the $PGDATA/data/pg_log file use for?

Whait is the $PGDATA/data/pg_log file use for?

From
Raymond Chui
Date:
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
command reduce that file size?

Thank you in advance!

--Raymond


Attachment

Re: Whait is the $PGDATA/data/pg_log file use for?

From
fabrizio.ermini@sysdat.it
Date:
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