Re: pg_standby / WAL archive-restore through system restarts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: d(dot)wall(at)computer(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby / WAL archive-restore through system restarts
Date: 2008-05-13 16:18:35
Message-ID: 27059.1210695515@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Wall <d(dot)wall(at)computer(dot)org> writes:
>> IIRC, it works conveniently in 8.2 and up. Just do pg_ctl stop -m fast.

> Thanks, Tom. What about if the postmaster is just killed (kill pid, or
> kill -9 pid) or the server/OS crashes? Will PG 8.3 in recovery mode be
> able to come back up okay and resume recovery?

Server crash is okay. kill -9 on a postmaster is never a good idea, for
reasons I don't feel like repeating --- see the archives.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-05-13 16:34:51 Re: too many warnings
Previous Message Joshua D. Drake 2008-05-13 16:16:56 Re: PG -v- MySQL