Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VKBVK-0001dr-EL for pgsql-admin@arkaria.postgresql.org; Thu, 12 Sep 2013 18:20:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VKBVJ-0005wB-Ns for pgsql-admin@arkaria.postgresql.org; Thu, 12 Sep 2013 18:20:33 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VKBVI-0005w4-EI for pgsql-admin@postgresql.org; Thu, 12 Sep 2013 18:20:32 +0000 Received: from cmailb.vita.virginia.gov ([166.67.65.182]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VKBVD-0001OB-KF for pgsql-admin@postgresql.org; Thu, 12 Sep 2013 18:20:30 +0000 X-SBRS: None X-HAT: Group: RELAYLIST_WHITELIST, Policy: $RELAYED_WHITELIST X-IronPort-AV: E=Sophos;i="4.90,892,1371096000"; d="scan'208,217";a="21766433" Received: from unknown (HELO COVMSGCES-HUB02.cov.virginia.gov) ([10.192.2.218]) by CRelayB.vita.virginia.gov with ESMTP/TLS/AES128-SHA; 12 Sep 2013 14:20:25 -0400 Received: from COVMSGCES-MBX01.cov.virginia.gov ([10.192.2.206]) by COVMSGCES-HUB02.cov.virginia.gov ([10.192.2.218]) with mapi id 14.03.0158.001; Thu, 12 Sep 2013 14:20:25 -0400 From: "Burgholzer, Robert (DEQ)" To: "pgsql-admin@postgresql.org" Subject: Is there a "Just Kidding" command? Thread-Topic: Is there a "Just Kidding" command? Thread-Index: Ac6v5L++bOKj7EaVTze07rOACmkqPQ== Date: Thu, 12 Sep 2013 18:20:24 +0000 Message-ID: <77F5F8FA4B407F43BFCFD3FC3478969150360B@COVMSGCES-MBX01> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.173.211.82] Content-Type: multipart/alternative; boundary="_000_77F5F8FA4B407F43BFCFD3FC3478969150360BCOVMSGCESMBX01_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_77F5F8FA4B407F43BFCFD3FC3478969150360BCOVMSGCESMBX01_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable So, I just sent a pg_ctl stop command to the wrong db node, and I'm wonderi= ng 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 requ= ests 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 --_000_77F5F8FA4B407F43BFCFD3FC3478969150360BCOVMSGCESMBX01_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

So, I just sent a pg_ctl stop command to the wrong d= b 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!!= 221; command?

 

/r/b

 

Robert  Burgholzer

Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply

804-869-3066

 

--_000_77F5F8FA4B407F43BFCFD3FC3478969150360BCOVMSGCESMBX01_--