pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedIs there a "Just Kidding" command?
4+ messages / 4 participants
[nested] [flat]
* Is there a "Just Kidding" command?
@ 2013-09-12 18:20 Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
0 siblings, 2 replies; 4+ messages in thread
From: Burgholzer, Robert (DEQ) @ 2013-09-12 18:20 UTC (permalink / raw)
To: pgsql-admin
So, I just sent a pg_ctl stop command to the wrong db node, and I'm wondering if there is a way to take that back? I ask since I have a long running process connecting to it, and I don't want to wait around for it to finish up so that the db can stop, then I can start it up again. Also, other requests are now being denied...
Here's hoping. Maybe the "doh!!" command?
/r/b
Robert Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is there a "Just Kidding" command?
@ 2013-09-12 21:43 David Johnston <polobo@yahoo.com>
parent: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
1 sibling, 0 replies; 4+ messages in thread
From: David Johnston @ 2013-09-12 21:43 UTC (permalink / raw)
To: pgsql-admin
Burgholzer, Robert (DEQ) wrote
> So, I just sent a pg_ctl stop command to the wrong db node, and I'm
> wondering if there is a way to take that back? I ask since I have a long
> running process connecting to it, and I don't want to wait around for it
> to finish up so that the db can stop, then I can start it up again. Also,
> other requests are now being denied...
>
> Here's hoping. Maybe the "doh!!" command?
At the admin level, not that I can think of. In SQL you have the "ROLLBACK"
command....you are using transactions right?
I could see the value in the normal shutdown sequence only blocking incoming
requests until it is ready for the full shutdown sequence and only then
beginning other shutdown actions. That would provide a window in this
situation to tell the server to "pg_ctl abort_shutdown" and go back to
allowing new connections. The cost-benefit of such a feature is fairly
small though.
Having done this your decision is to either kill the long-running stuff and
get the reboot over with or let it run and effectively make the server
unavailable for a while but you end up not having to re-do whatever work the
long-running transaction was in the middle of.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Is-there-a-Just-Kidding-command-tp5770628p5770642.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is there a "Just Kidding" command?
@ 2013-09-13 08:12 Martin French <Martin.French@romaxtech.com>
parent: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
1 sibling, 1 reply; 4+ messages in thread
From: Martin French @ 2013-09-13 08:12 UTC (permalink / raw)
To: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>; +Cc: pgsql-admin; pgsql-admin-owner@postgresql.org
Not that I am aware of.
I must admit, I've needed the "OMG Wrong Command" command myself a few
times over the years.
From: "Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
Date: 12/09/2013 19:27
Subject: [ADMIN] Is there a "Just Kidding" command?
Sent by: pgsql-admin-owner@postgresql.org
So, I just sent a pg_ctl stop command to the wrong db node, and I’m
wondering if there is a way to take that back? I ask since I have a long
running process connecting to it, and I don’t want to wait around for it
to finish up so that the db can stop, then I can start it up again. Also,
other requests are now being denied...
Here’s hoping. Maybe the “doh!!” command?
/r/b
Robert Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066
=============================================
Romax Technology Limited
A limited company registered in England and Wales.
Registered office:
Rutherford House
Nottingham Science and Technology Park
Nottingham
NG7 2PZ
England
Registration Number: 2345696
VAT Number: 526 246 746
Telephone numbers:
+44 (0)115 951 88 00 (main)
For other office locations see:
http://www.romaxtech.com/Contact
=================================
===============
E-mail: info@romaxtech.com
Website: www.romaxtech.com
=================================
================
Confidentiality Statement
This transmission is for the addressee only and contains information that
is confidential and privileged.
Unless you are the named addressee, or authorised to receive it on behalf
of the addressee
you may not copy or use it, or disclose it to anyone else.
If you have received this transmission in error please delete from your
system and contact the sender. Thank you for your cooperation.
=================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Is there a "Just Kidding" command?
@ 2013-09-13 11:03 Robert Burgholzer <rburghol@vt.edu>
parent: Martin French <Martin.French@romaxtech.com>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Burgholzer @ 2013-09-13 11:03 UTC (permalink / raw)
To: pgsql-admin
Thanks for the responses folks - I went with the approach that David
mentioned, just chilled out and let the running tasks finish and then
restarted the node. Ultimately, in terms of cost-benefit, I spent 10
minutes watching this process lay out, and only got one email about a
non-responsive app, so, very small indeed.
/r/b
On Fri, Sep 13, 2013 at 4:12 AM, Martin French
<Martin.French@romaxtech.com>wrote:
> Not that I am aware of.
>
> I must admit, I've needed the "OMG Wrong Command" command myself a few
> times over the years.
>
>
>
>
> From: "Burgholzer, Robert (DEQ)" <
> Robert.Burgholzer@deq.virginia.gov>
> To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
> Date: 12/09/2013 19:27
> Subject: [ADMIN] Is there a "Just Kidding" command?
> Sent by: pgsql-admin-owner@postgresql.org
> ------------------------------
>
>
>
> So, I just sent a pg_ctl stop command to the wrong db node, and I’m
> wondering if there is a way to take that back? I ask since I have a long
> running process connecting to it, and I don’t want to wait around for it to
> finish up so that the db can stop, then I can start it up again. Also,
> other requests are now being denied...
>
> Here’s hoping. Maybe the “doh!!” command?
>
> /r/b
>
> Robert Burgholzer
> Surface Water Modeler
> Virginia DEQ Office of Surface and Ground Water Supply
> 804-869-3066
>
>
> =============================================
>
> Romax Technology Limited
> A limited company registered in England and Wales.
> Registered office:
> Rutherford House
> Nottingham Science and Technology Park
> Nottingham
> NG7 2PZ
> England
> Registration Number: 2345696
> VAT Number: 526 246 746
>
> Telephone numbers:
> +44 (0)115 951 88 00 (main)
>
> For other office locations see:
> http://www.romaxtech.com/Contact
> =================================
> ===============
> E-mail: info@romaxtech.com
> Website: www.romaxtech.com
> =================================
>
> ================
> Confidentiality Statement
> This transmission is for the addressee only and contains information that
> is confidential and privileged.
> Unless you are the named addressee, or authorised to receive it on behalf
> of the addressee
> you may not copy or use it, or disclose it to anyone else.
> If you have received this transmission in error please delete from your
> system and contact the sender. Thank you for your cooperation.
> =================================================
--
--
Robert W. Burgholzer
'Making the simple complicated is commonplace; making the complicated
simple, awesomely simple, that's creativity.' - Charles Mingus
Athletics: http://athleticalgorithm.wordpress.com/
Science: http://robertwb.wordpress.com/
Wine: http://reesvineyard.wordpress.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-09-13 11:03 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-12 18:20 Is there a "Just Kidding" command? Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
2013-09-12 21:43 ` David Johnston <polobo@yahoo.com>
2013-09-13 08:12 ` Martin French <Martin.French@romaxtech.com>
2013-09-13 11:03 ` Robert Burgholzer <rburghol@vt.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox