Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XbXfz-0001sk-Eh for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 16:31:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XbXfy-0000sh-SN for pgsql-admin@arkaria.postgresql.org; Tue, 07 Oct 2014 16:31:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XbXfx-0000qH-Gt for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 16:31:49 +0000 Received: from doctor.nl2k.ab.ca ([204.209.81.1]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XbXfo-0000YC-PK for pgsql-admin@postgresql.org; Tue, 07 Oct 2014 16:31:47 +0000 Received: from localhost.nl2k.ab.ca ([127.0.0.1] helo=localhost ident=doctor) by doctor.nl2k.ab.ca with esmtp (Exim 4.84) (envelope-from ) id 1XbXfb-0003N4-KL; Tue, 07 Oct 2014 10:31:34 -0600 Date: Tue, 7 Oct 2014 10:31:24 -0600 From: The Doctor To: Scott Marlowe Cc: "pgsql-admin@postgresql.org" Subject: Re: Suspending postgresql during heavy load Message-ID: <20141007163123.GA12243@doctor.nl2k.ab.ca> References: <20141007150713.GA29776@doctor.nl2k.ab.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.1 (-) 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 On Tue, Oct 07, 2014 at 09:17:47AM -0600, Scott Marlowe wrote: > On Tue, Oct 7, 2014 at 9:07 AM, The Doctor wrote: > > Question is their a way to suspend PostGres during a heavy average load > > session? > > > > I would like to suspend Postgresql transaction on a load average higher > > then a load average of 5. > > So you just want to stop the db under heavy load? I'm not sure what > you're asking here. PostgreSQL is designed around a transactional > model, it can't just be shut off at your convenience. > > OTOH you might want to look at how you're using it and what kind of > hardware you're using and if you need to upgrade it. In this case PostGresQL 9.3.5 taking on brute force attacks from Blog Spammers using Serendity . I have yused mod_limits to limit the damage from the brute force wep spam attack, but this is turing the web server off for about 120 s and I would like to turn away these pests forver. -- Member - Liberal International This is doctor@@nl2k.ab.ca Ici doctor@@nl2k.ab.ca God,Queen and country!Never Satan President Republic!Beware AntiChrist rising! http://www.fullyfollow.me/rootnl2k Look at Psalms 14 and 53 on Atheism Truth is a gaffe to liars. -unknown -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin