Hi,
On Wed, Nov 4, 2009 at 12:01 AM, Andrew Gierth
wrote:
> 2) you're starting up in a data dir that is a restore of a base backup,
> but no recovery.conf has been created
Is the scenario 2 (i.e., a normal crash recovery without recovery.conf)
supported in postgres? But, anyway, it's possible
[ after further thought... ]
Andrew Gierth writes:
> How do you distinguish between these two scenarios:
> 1) you're starting up in a data dir where you crashed in the middle of
>a backup
> 2) you're starting up in a data dir that is a restore of a base backup,
>but no recovery.conf has
> "Albe" == "Albe Laurenz" writes:
Albe> Removing postmaster.pid can lead to a corrupt database.
Albe> Removing backup_label means that one of your backups will go
Albe> wrong, and a subsequent pg_stop_backup() will throw an error.
Albe> If you have a cluster failover during an online ba
Tom Lane wrote:
> > I wonder why backup_label isn't automatically removed
> > in normal crash recovery case.
>
> Removing it automatically could be catastrophic if done
> incorrectly, no?
>
> It would be no less catastrophic if done incorrectly from outside the
> postmaster; see for example the
Fujii Masao writes:
> I wonder why backup_label isn't automatically removed
> in normal crash recovery case.
Removing it automatically could be catastrophic if done incorrectly, no?
> If that's intentional, a clusterware for shared disk
> failover system should remove backup_label whenever
> doi
Fujii Masao wrote:
> When a crash occurs before calling pg_stop_backup(),
> the subsequent crash recovery causes the FATAL error
> and outputs the following HINT message.
>
> If you are not restoring from a backup, try removing the file
> \"%s/backup_label\"."
>
> I wonder why backup_label is
Hi,
When a crash occurs before calling pg_stop_backup(),
the subsequent crash recovery causes the FATAL error
and outputs the following HINT message.
If you are not restoring from a backup, try removing the file
\"%s/backup_label\"."
I wonder why backup_label isn't automatically removed
in n
