Re: [ADMIN] WAL log archive frequency

2006-01-19 Thread Bruce Momjian
Tom Lane wrote: > Chris Jewell <[EMAIL PROTECTED]> writes: > > Further to my question on PITR, I have now implemented it :-) However, > > I was wondering about the frequency of archiving the WAL. Does > > postgresql wait until the current WAL file has reached 16MB before > > calling the archive_c

Re: [ADMIN] WAL log archive frequency

2006-01-19 Thread Tom Lane
Chris Jewell <[EMAIL PROTECTED]> writes: > Further to my question on PITR, I have now implemented it :-) However, > I was wondering about the frequency of archiving the WAL. Does > postgresql wait until the current WAL file has reached 16MB before > calling the archive_command? Yes. The assumpt

[ADMIN] WAL log archive frequency

2006-01-19 Thread Chris Jewell
Hi, Further to my question on PITR, I have now implemented it :-) However, I was wondering about the frequency of archiving the WAL. Does postgresql wait until the current WAL file has reached 16MB before calling the archive_command? The reason why I ask is that last night, after doing the base