Sylvain Simard <[EMAIL PROTECTED]> writes:
> At begin, with a new database the pg_log are 40k
> After many days my pg_log is come 3884k
pg_log grows at the rate of 2 bits per transaction.
> It's possible to initialize it? If yes how...
dump ... initdb ... reload.
> It's possible to do anything
the only way of initializing it (to the best of my knowledge) is to backup
your databases (pg_dump) and a re-initdb of the database ... one person
recently rm'd the pg_log and found out just how disasterous that is :(
btw, would heavily recomment upgrading to 7.0.2 while you are at it, which
has
Hi my name is Sylvain
I use Postgres 6.5.3-3
Why is the pg_log???
I have a program than run 24hrs/day and many transaction has been send
to postgres
eg (select, insert, update, vacuum, (begin work-commit work)...)
At begin, with a new database the pg_log are 40k
After many days my pg_log is come
