"Steve Oualline" <[EMAIL PROTECTED]> writes:
> We have a system with 1202 files in the WAL directory (pg_xlog).
> When we start postmaster, it goes into the starting state for 5 minutes
> and then crashes.
Define "crash". If you don't show us the *exact* messages you're
seeing, it's difficult to
Title: WAL questions
We have a system with 1202 files in the WAL directory (pg_xlog).
When we start postmaster, it goes into the starting state for 5 minutes
and then crashes.
Questions:
1) What is the biggest number of WAL files you've seen and what were
you doing to the database at
"Robert B. Easter" <[EMAIL PROTECTED]> writes:
> What is there for a user or admin or programmer to know about the new WAL
> stuff?
Vadim is the man who ought to answer this (and he's on the hook to write
a lot of documentation before 7.1 ships ;-)). But my understanding is
that as of 7.1, WAL
What is there for a user or admin or programmer to know about the new WAL
stuff? What all does it do? Does it allow for an audit file to be created,
which can be used to playback and/or rewind the transactions on the database
by user/admin commands? How do checkpoints limit or affect how far