Re: [ADMIN] Another WAL question

In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no need to keep them after a checkpoint. Is there any need to have these WAL config paramaters anymore? I missed what's you propose to remove. I am not proposing to remove anything. I just want to make sure

[ADMIN] Another WAL question

Robert F. mentioned that there is a config parameter controlling the number of WAL files in postgresql.conf. I just looked at the Doc on this I found WAL_FILES, which appears to specify the number of files to create in advance, but it is no clear to me that this limits the total number of WAL

Re: [ADMIN] Another WAL question

In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no need to keep them after a checkpoint. Is there any need to have these WAL config paramaters anymore? We currently have in postgresql.conf: #wal_buffers = 8# min 4 #wal_files = 0 # range 0-64 #wal_sync_method =

Re: [ADMIN] Another WAL question

In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no need to keep them after a checkpoint. This answers my original question- it sounds like after 3, they get recycled or deleted, so if I reserve 48Mb (3*16) for these, I should be OK. ...Right? Is there any need to have

Re: [ADMIN] Another WAL question

In 7.1.3 and 7.2, there are only 2-3 WAL files kept because there is no need to keep them after a checkpoint. Is there any need to have these WAL config paramaters anymore? I missed what's you propose to remove. I am not proposing to remove anything. I just want to make sure they are

[ADMIN] Another WAL question (sort of)

Two sort of WAL related questions 1) Is point-in-time recovery using a pg_dumpall and the associated WAL files still planned for 7.2? 2) When is 7.2 planned to be released? -crl -- Chad R. Larson (CRL22)[EMAIL PROTECTED] Eldorado Computing, Inc. 602-604-3100 5353