| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | pgsql-docs-owner(at)postgresql(dot)org |
| Subject: | Proposed doc-patch: Identifying the Current WAL file |
| Date: | 2006-04-12 09:02:49 |
| Message-ID: | 443CC239.7010303@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg윈 토토SQL : Postg윈 토토SQL 메일 링리스트 : 2006-04-12 이후 PGSQL-DOCS |
Reading Tom's posting here:
http://archives.postgresql.org/pgsql-general/2006-04/msg00499.php
I just realised we don't seem to mention this in the docs anywhere. I
propose adding a short paragraph to 23.3.1
http://www.postgresql.org/docs/8.1/static/backup-online.html#BACKUP-ONLINE-CAVEATS
After "Except in the case of retrying a failure, it will be called only
once for any given file name."
To identify the current, partially-filled WAL segment, sort first by
mtime and second by file name. That is, take the latest mtime among the
properly-named files, breaking ties by taking the higher filename.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2006-04-13 16:58:21 | Proposed doc-patch: Identifying the Current WAL file |
| Previous Message | Bruce Momjian | 2006-04-11 15:48:10 | Re: Updated Russian translation of the FAQ |