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 Patches > Re: Improve shu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 8 of 9 Topic 3627 of 4091
Post > Topic >>

Re: Improve shutdown during online backup, take 4

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 26, 2008 at 06:51 PM

"Albe Laurenz" <laurenz.albe@[EMAIL PROTECTED]
> writes:
> Tom Lane wrote:
>> If you actually want the behavior you propose, then the only correct
way
>> to implement it is to embed it into the state machine logic, ie, do the
>> CancelBackup inside PostmasterStateMachine in some state transition
>> taken after the last child is gone.

> I've attached a patch that works for me. I hope I got it right.

Applied with additional cleanup.  You hadn't thought very carefully
about additional state transitions that would have to be introduced
into the postmaster state machine to sup****t a new state --- for
example, as coded a SIGINT delivered to the postmaster after SIGTERM
would fail to do anything at all, when of course it really ought to
force us into fast shutdown.  Also, it's not really that hard to
disallow non-superusers from connecting in PM_WAIT_BACKUP state.

			regards, tom lane

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 9 Posts in Topic:
Re: Improve shutdown during online backup, take 4
magnus@[EMAIL PROTECTED]   2008-04-23 16:08:36 
Re: Improve shutdown during online backup, take 4
tgl@[EMAIL PROTECTED] (T  2008-04-23 11:59:11 
Re: Improve shutdown during online backup, take 4
tgl@[EMAIL PROTECTED] (T  2008-04-24 10:25:25 
Re: Improve shutdown during online backup, take 4
tgl@[EMAIL PROTECTED] (T  2008-04-24 11:56:27 
Re: Improve shutdown during online backup, take 4
laurenz.albe@[EMAIL PROTE  2008-04-25 09:00:59 
Re: Improve shutdown during online backup, take 4
tgl@[EMAIL PROTECTED] (T  2008-04-25 10:22:38 
Re: Improve shutdown during online backup, take 4
laurenz.albe@[EMAIL PROTE  2008-04-25 17:12:19 
Re: Improve shutdown during online backup, take 4
tgl@[EMAIL PROTECTED] (T  2008-04-26 18:51:49 
Re: Improve shutdown during online backup, take 4
laurenz.albe@[EMAIL PROTE  2008-04-28 08:57:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Mon Oct 13 3:58:20 CDT 2008.