preventing the effective fork bomb when restarting a high traffic server?

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: preventing the effective fork bomb when restarting a high traffic server?
Date: 2004-12-13 19:24:46
Message-ID: A62361DA-4D3C-11D9-8178-000D9366F0C4@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a PG server that handles a pretty good amount of traffic.
Typically the connections are going through pgpool, which is a godsend.

The problem I'm encountering is when I restart PG for whatever reason
it takes it a long time to come back fully online: the reason: the
machine is dealing with over 100 connection attempts / second while
trying to replay the logical logs. (And they are always getting the
"system is coming up" message) (The connection attempts are all from
the pools trying to reconnect up)

Someone on irc suggested perhaps altering pg_hba to disallow
connections from my frontends while it comes back. I haven't done any
tests on this yet but was wondering if anybody else has had this
experience.

if this isn't the case perhaps it may make sense to delay the creation
of the sockets until after log replay is done. (Afterall, the db is
useless until this happens).

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2004-12-13 19:43:16 From latin9 to sql_ascii??
Previous Message Ericson Smith 2004-12-13 15:11:06 Re: Tyan Thunder MB for postgres server