Re: pg_log (PostgreSQL)
Michel Tremblay wrote:
>I use pgsql 6.5.3
>What's the pg_log?
>
>Why the pg_log come bigger
>when many transaction is execute, vacuum update etc...
>in my database?
>
>it's possible to reinitialise the pg_log?
pg_log is poorly named. It is not a log file. DO NOT touch it!
It records the state of every transaction in your database; if you
lose pg_log you lose your data!
I'm copying this to the users list to ensure wider coverage for this
information.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Only take heed to thyself, and keep thy soul
diligently, lest thou forget the things which thine
eyes have seen, and lest they depart from thy heart
all the days of thy life; but teach them to thy sons,
and to thy sons' sons..." Deuteronomy 4:9
Reply to: