Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 13 May 2008 12:18:35 -0400
- Message-id: <27059(dot)1210695515(at)sss(dot)pgh(dot)pa(dot)us>
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
- References:
- pg_standby / WAL archive-restore through system restarts
- From: David Wall
- Re: pg_standby / WAL archive-restore through system restarts
- From: Guillaume Lelarge
- Re: pg_standby / WAL archive-restore through system restarts
- From: David Wall
- Re: pg_standby / WAL archive-restore through system restarts
- From: Tom Lane
- Re: pg_standby / WAL archive-restore through system restarts
- From: David Wall
- pg_standby / WAL archive-restore through system restarts
- Prev by Date: Re: PG -v- MySQL
- Next by Date: Re: too many warnings
- Previous by thread: Re: pg_standby / WAL archive-restore through system restarts
- Next by thread: problem with importing dbf file into postgresql using navicat on mac OS X
- Indexes: