Re: [GENERAL] WAL questions

2006-01-27 Thread Tom Lane
"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

[GENERAL] WAL questions

2006-01-27 Thread Steve Oualline
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

Re: [GENERAL] WAL questions

2001-01-08 Thread Tom Lane
"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

[GENERAL] WAL questions

2001-01-08 Thread Robert B. Easter
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