Re: pg_standby / WAL archive-restore through system restarts

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


>> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-05-13 16:14:05 Re: PG -v- MySQL
Previous Message Douglas McNaught 2008-05-13 16:12:07 Re: rounding problems