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

From Josh Berkus
Subject Re: pg_stop_backup does not complete
Date
Msg-id 4B858CDC.6000505@agliodbs.com
Whole thread Raw
In response to Re: pg_stop_backup does not complete  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: pg_stop_backup does not complete  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: pg_stop_backup does not complete  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: pg_stop_backup does not complete  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: pg_stop_backup does not complete  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_stop_backup does not complete  (Greg Smith <greg@2ndquadrant.com>)
Re: pg_stop_backup does not complete  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
> pg_stop_backup() doesn't complete until all the WAL segments needed to
> restore from the backup are archived. If archive_command is failing,
> that never happens.

OK, so we need a way out of that cycle if the user is issuing
pg_stop_backup because they *already know* that archive_command is
failing.  Right now, there's no way out other than a fast shutdown,
which is a bit user-hostile.

--Josh Berkus


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: A thought on Index Organized Tables
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_stop_backup does not complete