Re: pg_standby / WAL archive-restore through system restarts - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_standby / WAL archive-restore through system restarts
Date
Msg-id 27059.1210695515@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_standby / WAL archive-restore through system restarts  (David Wall <d.wall@computer.org>)
List pgsql-general
David Wall <d.wall@computer.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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PG -v- MySQL
Next
From: Tom Lane
Date:
Subject: Re: too many warnings