Re: pg_stop_backup does not complete - Mailing list pgsql-hackers

From Greg Stark
Subject Re: pg_stop_backup does not complete
Date
Msg-id 407d949e1002250708p71bc870blf45ac9547c8a9a75@mail.gmail.com
Whole thread Raw
In response to Re: pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
Re: pg_stop_backup does not complete  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
On Wed, Feb 24, 2010 at 11:14 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
> Right.  I'm pointing out that production and "trying out 9.0 for the
> first time" are actually different circumstances, and we need to be able
> to handle both gracefully.  Since, if people have a bad experience
> trying it out for the first time, we'll never *get* to production.

Fwiw if it's not clear what's going on when you're trying out
something carefully for the first time it's 10x worse if you're stuck
in a situation like this when you have people breathing down your neck
yelling about how they're losing money for every second you're down.

In an ideal world it would be best if pg_stop_backup could actually
print the error status of the archiving command. Is there any way for
it to get ahold of the fact that the archiving is failing?

And do we have closure on whether a "fast" shutdown is hanging? Or was
that actually a smart shutdown?

Perhaps "smart" shutdown needs to print out what it's waiting on
periodically as well, and suggest a fast shutdown to abort those
transactions.

--
greg


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Recent vendor SSL renegotiation patches break PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Recent vendor SSL renegotiation patches break PostgreSQL