David Wall <d.wall@xxxxxxxxxxxx> 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
