preventing the effective fork bomb when restarting a high traffic server?
От | Jeff |
---|---|
Тема | preventing the effective fork bomb when restarting a high traffic server? |
Дата | |
Msg-id | A62361DA-4D3C-11D9-8178-000D9366F0C4@torgo.978.org обсуждение исходный текст |
Ответы |
Re: preventing the effective fork bomb when restarting a high traffic server?
|
Список | 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@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
В списке pgsql-admin по дате отправления: