Skip site navigation (1) Skip section navigation (2)

BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-docspgsql-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.

Responses

pgsql-docs by date

Next:From: Fujii MasaoDate: 2008-12-06 04:29:10
Subject: Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION
Previous:From: Magnus HaganderDate: 2008-12-03 14:26:42
Subject: Re: contact details in contrib module documentation

pgsql-hackers by date

Next:From: Kurt HarrimanDate: 2008-12-05 14:51:50
Subject: Re: Mostly Harmless: Welcoming our C++ friends
Previous:From: Devrim GÜNDÜZDate: 2008-12-05 14:41:00
Subject: Re: Versioned mo file installation

pgsql-bugs by date

Next:From: Alexander Gallardo TorresDate: 2008-12-05 15:40:14
Subject: download PostgreSQL 8.0.2
Previous:From: Tom LaneDate: 2008-12-05 14:20:52
Subject: Re: BUG #4563: Translation of errors.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group