Re: pg_stop_backup running for 2h10m? - Mailing list pgsql-general

From François Beausoleil
Subject Re: pg_stop_backup running for 2h10m?
Date
Msg-id 8ABA25C2-D0E6-4030-BEA6-20DF7F6C27DE@teksol.info
Whole thread Raw
In response to Re: pg_stop_backup running for 2h10m?  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
Le 2013-04-23 à 16:25, Kevin Grittner a écrit :

> François Beausoleil <francois@teksol.info> wrote:
>
>> xlogs aren't being added to the backup directory.
>
> Any clue in the server log why that is?

I checked but didn't mention it. I ended up calling pg_cancel_backend() on the process, after 3h. strace on the process
revealedpg_stop_backup was doing stat('pg_xlog/archive_status/000###.ready'), but the file never appeared. 

As I said, I had written a bad omnipitr command, and was trying to backup to a non-existent host, which would have
failed.

I'm recovered now and the backup's going.

Bye,
François
Attachment

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: pg_stop_backup running for 2h10m?
Next
From: Kevin Grittner
Date:
Subject: Re: Log messages regarding automatic vacuum and exclusive locks