From: | "Randy Isbell" <jisbell(at)cisco(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION |
Date: | 2008-12-05 14:41:16 |
Message-ID: | 200812051441.mB5EfG1M007309@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-docs pgsql-hackers |
The following bug has been logged online:
Bug reference: 4566
Logged by: Randy Isbell
Email address: jisbell(at)cisco(dot)com
PostgreSQL version: 8.3.4
Operating system: FreeBSD 6.2
Description: pg_stop_backup() reports incorrect STOP WAL LOCATION
Details:
An inconsistency exists between the segment name reported by
pg_stop_backup() and the actual WAL file name.
SELECT pg_start_backup('filename');
pg_start_backup
-----------------
10/FE1E2BAC
(1 row)
Later:
SELECT pg_stop_backup();
pg_stop_backup
----------------
10/FF000000
(1 row)
The resulting *.backup file:
START WAL LOCATION: 10/FE1E2BAC (file 0000000200000010000000FE)
STOP WAL LOCATION: 10/FF000000 (file 0000000200000010000000FF)
CHECKPOINT LOCATION: 10/FE1E2BAC
START TIME: 2008-11-09 01:15:06 CST
LABEL: /bck/db/sn200811090115.tar.gz
STOP TIME: 2008-11-09 01:15:48 CST
In my 8.3.4 instance, WAL file naming occurs as:
...
0000000100000003000000FD
0000000100000003000000FE
000000010000000400000000
000000010000000400000001
...
WAL files never end in 'FF'. This causes a problem when trying to collect
the ending WAL file for backup.
- r.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Gallardo Torres | 2008-12-05 15:40:14 | download PostgreSQL 8.0.2 |
Previous Message | Tom Lane | 2008-12-05 14:20:52 | Re: BUG #4563: Translation of errors. |
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2008-12-06 04:29:10 | Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION |
Previous Message | Magnus Hagander | 2008-12-03 14:26:42 | Re: contact details in contrib module documentation |
From | Date | Subject | |
---|---|---|---|
Next Message | Kurt Harriman | 2008-12-05 14:51:50 | Re: Mostly Harmless: Welcoming our C++ friends |
Previous Message | Devrim GÜNDÜZ | 2008-12-05 14:41:00 | Re: Versioned mo file installation |