Postgres Pro
Downloads
Home   >   mailing lists

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

From David Wall
Subject Re: pg_standby / WAL archive-restore through system restarts
Date
Msg-id 4829BE2D.1040500@computer.org
Whole thread Raw
In response to Re: pg_standby / WAL archive-restore through system restarts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_standby / WAL archive-restore through system restarts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 

Thanks, Guillaume.  Can anyone confirm his answer to the question below 
about restarting the backup postmaster?    
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?

David

pgsql-general by date:

Previous
From: "Douglas McNaught"
Date:
Subject: Re: rounding problems
Next
From: "Scott Marlowe"
Date:
Subject: Re: PG -v- MySQL