From: The Doctor <doctor@doctor.nl2k.ab.ca>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Suspending postgresql during heavy load
Date: Tue, 7 Oct 2014 10:31:24 -0600
Message-ID: <20141007163123.GA12243@doctor.nl2k.ab.ca> (raw)
In-Reply-To: <CAOR=d=1bHSfiWX7MJzEJ2-SNFJADDn+V0R6SKi5nZoTQ0DR8AQ@mail.gmail.com>
References: <20141007150713.GA29776@doctor.nl2k.ab.ca>
<CAOR=d=1bHSfiWX7MJzEJ2-SNFJADDn+V0R6SKi5nZoTQ0DR8AQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Tue, Oct 07, 2014 at 09:17:47AM -0600, Scott Marlowe wrote:
> On Tue, Oct 7, 2014 at 9:07 AM, The Doctor <doctor@doctor.nl2k.ab.ca> 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
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: doctor@doctor.nl2k.ab.ca, scott.marlowe@gmail.com
Subject: Re: Suspending postgresql during heavy load
In-Reply-To: <20141007163123.GA12243@doctor.nl2k.ab.ca>
* 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