From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Is there a "Just Kidding" command?
Date: Thu, 12 Sep 2013 14:43:54 -0700 (PDT)
Message-ID: <1379022234233-5770642.post@n5.nabble.com> (raw)
In-Reply-To: <77F5F8FA4B407F43BFCFD3FC3478969150360B@COVMSGCES-MBX01>
References: <77F5F8FA4B407F43BFCFD3FC3478969150360B@COVMSGCES-MBX01>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: polobo@yahoo.com
Subject: Re: Is there a "Just Kidding" command?
In-Reply-To: <1379022234233-5770642.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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