Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Linux-HA: Dev

[PATCH] recovering from the online backup failure

 

 

Linux-HA dev RSS feed   Index | Next | Previous | View Threaded


ikedaj at intellilink

Nov 10, 2009, 12:02 AM

Post #1 of 2 (444 views)
Permalink
[PATCH] recovering from the online backup failure

Hi,

If some failures happen during the online backup of PostgreSQL,
pgsql can not handle the fail over,
because "backup_label", this is a file for a backup process of Postgres,
remains on the shared disk.
pgsql can not start DB if this file remains.
Please see the attached.

Thanks,
Junko
Attachments: pgsql.patch (0.94 KB)


ikedaj at intellilink

Nov 10, 2009, 9:58 PM

Post #2 of 2 (399 views)
Permalink
Re: [PATCH] recovering from the online backup failure [In reply to]

Hi,

This issue is related to this list.
http://archives.postgresql.org/pgsql-hackers/2009-11/msg00024.php

PostgreSQL might become able to remove its lock file automatically in the
future,
but cluster software should be take care of it.
It seems that oracle RA handles this situation with running ora_cleanup
function which removes a lock file.

Serge,
What do you think of this patch?

Thanks,
Junko

On Tue, 10 Nov 2009 17:02:03 +0900, Junko IKEDA <ikedaj [at] intellilink>
wrote:

> Hi,
>
> If some failures happen during the online backup of PostgreSQL,
> pgsql can not handle the fail over,
> because "backup_label", this is a file for a backup process of Postgres,
> remains on the shared disk.
> pgsql can not start DB if this file remains.
> Please see the attached.
>
> Thanks,
> Junko

_______________________________________________________
Linux-HA-Dev: Linux-HA-Dev [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Linux-HA dev RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.