| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sebastian Reitenbach" <sebastia(at)l00-bugdead-prods(dot)de> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: backup WAL files, |
| Date: | 2008-01-15 15:41:42 |
| Message-ID: | 23896.1200411702@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Sebastian Reitenbach" <sebastia(at)l00-bugdead-prods(dot)de> writes:
> The WAL files have names like this:
> 00000001000000010000003C
> I am wonder what the meaning of the two 1 in the filename is?
The first one (the first 8 hex digits actually) are the current
"timeline" number. The second one isn't very interesting, it's
an artifact of the way that WAL file locations are converted to
file names internally.
> Are the WAL
> file names counted up to FFFFFFFFFFFFFFFFFFFFFFFFF ?
> Then I'll run into problems anyways as these int number are too large to be
> handled by bash.
You definitely should not expect to convert the names to integers.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ertel, Steve | 2008-01-15 15:59:54 | data table files |
| Previous Message | Jean-Marc Pigeon | 2008-01-15 15:32:27 | Postgresql 8.2 AUTOVACUUM LOG |