Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: pg_standby ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 9 Topic 15509 of 17437
Post > Topic >>

Re: pg_standby / WAL archive-restore through system restarts

by d.wall@[EMAIL PROTECTED] (David Wall) May 13, 2008 at 09:13 AM

This is a multi-part message in MIME format.
--------------020104040108040509040404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


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

--------------020104040108040509040404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<blockquote cite="mid:26519.1210694077@[EMAIL PROTECTED]
" type="cite">
  <blockquote type="cite">
    <pre wrap="">Thanks, Guillaume.  Can anyone confirm his answer to the
question below 
about restarting the backup postmaster? 
    </pre>
  </blockquote>
  <pre wrap=""><!---->
IIRC, it works conveniently in 8.2 and up.  Just do pg_ctl stop -m fast.
  </pre>
</blockquote>
<br>
Thanks, Tom.&nbsp; What about if the postmaster is just killed (kill pid,
or
kill -9 pid) or the server/OS crashes?&nbsp; Will PG 8.3 in recovery mode
be
able to come back up okay and resume recovery?<br>
<br>
David<br>
</body>
</html>

--------------020104040108040509040404--
 




 9 Posts in Topic:
pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-12 08:51:58 
Re: pg_standby / WAL archive-restore through system restarts
guillaume@[EMAIL PROTECTE  2008-05-13 14:37:26 
Re: pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-13 08:27:47 
Re: pg_standby / WAL archive-restore through system
alvherre@[EMAIL PROTECTED  2008-05-13 11:31:58 
Re: pg_standby / WAL archive-restore through system restarts
guillaume@[EMAIL PROTECTE  2008-05-13 18:48:38 
Re: pg_standby / WAL archive-restore through system restarts
tgl@[EMAIL PROTECTED] (T  2008-05-13 11:54:37 
Re: pg_standby / WAL archive-restore through system restarts
d.wall@[EMAIL PROTECTED]   2008-05-13 09:13:33 
Re: pg_standby / WAL archive-restore through system restarts
tgl@[EMAIL PROTECTED] (T  2008-05-13 12:18:35 
Re: pg_standby / WAL archive-restore through
xzilla@[EMAIL PROTECTED]   2008-05-13 14:23:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:45:30 CST 2008.