| From: | fabrizio(dot)ermini(at)sysdat(dot)it |
|---|---|
| To: | Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Whait is the $PGDATA/data/pg_log file use for? |
| Date: | 2001-05-11 16:17:39 |
| Message-ID: | 3AFC2CC3.4403.1F9D6AE@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)tin(dot)it
loc. Meleto Valdarno Mail on GSM: (keep it short!)
52020 Cavriglia (AR) faermini(at)sms(dot)tin(dot)it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Crotwell | 2001-05-11 16:20:50 | Re: defunct postmasters |
| Previous Message | John Coers | 2001-05-11 16:11:02 | RPM problem |