| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | Mason Hale <mason(at)onespot(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: unable to fail over to warm standby server |
| Date: | 2010-01-29 18:48:37 |
| Message-ID: | 603c8f071001291048q719afa32rc44a541824ca509c@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Jan 29, 2010 at 11:02 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> You seem to focus on the above trouble. I think that this happened because
> recovery.conf was deleted and restore_command was not given. In fact, the
> WAL file (e.g., pg_xlog/0000000200003C82000000A3) required for recovery
> was unable to be restored from the archive because restore_command was
> not supplied. Then recovery failed.
>
> If the sysadmin had left the recovery.conf and removed the trigger file,
> pg_standby in restore_command would have restored all WAL files required
> for recovery, and recovery would advance well.
That may be true, but it's certainly seems unfortunate that we don't
handle this case a bit more gracefully.
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian Nigsch | 2010-01-29 19:07:37 | BUG #5302: WIN1252 encoding causes server memory leak |
| Previous Message | Mike Bresnahan | 2010-01-29 18:35:33 | Re: Amazon EC2 CPU Utilization |