Em 08-02-2011 17:35, Thom Brown escreveu:
> This could do with a bit more documentation about usage. Below the
> Backup Control Functions table
> each function has a paragraph detailing what it does.
I forgot to check it.
> Also, I notice you can easily write over a label. The case I'm
> thinking of is someone in psql creating a named restore point, then
> later on, they go in again, accidentally cursor up and select the
> previous statement and create it again. Would this mean that the
> previous label is lost, or would it be the case that any subsequent
> duplicate labels would have no effect unless the WAL files with the
> original label in were consumed? In either case, a note in the docs
> about this would be useful.
This is a limitation that I pointed out  but people decided to postpone
named restore point management. The first one is used as restore point. I
added it in the attached patch.
> And I don't see these label creations getting logged either. Could we
> output that to the log because at least then users can grep the
> directory for labels, and, in most cases, the time they occurred?
Good point. I included location instead of time; time is already supplied by
The following patch implements the Thom's suggestions.
Euler Taveira de Oliveira
Description: text/x-patch (1.4 KB)
In response to
pgsql-hackers by date
|Next:||From: Marko Tiikkaja||Date: 2011-02-24 15:57:27|
|Subject: Re: Review: Fix snapshot taking inconsistencies|
|Previous:||From: Tom Lane||Date: 2011-02-24 15:21:41|
|Subject: Re: Review: Fix snapshot taking inconsistencies |