The uselessness of pgbouncer PAUSE

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: The uselessness of pgbouncer PAUSE
Date: 2014-01-16 00:08:50
Message-ID: 52D72312.4040202@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Sergey,

I looked into this today, and it doesn't help at all. PAUSE will wait
for all current queries to complete before switching over, which isn't
tolerable in a failover situation. Unfortunately, there seems to be no
command which says "kill running query connections but leave idle
connections alone". Possible this is the idea behind SUSPEND, but if
so, it doesn't work.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse sfpug by date

  From Date Subject
Next Message Josh Berkus 2014-01-16 00:16:24 Re: Creating a custom email token parser for FTS
Previous Message Brian Ghidinelli 2014-01-15 02:09:42 Creating a custom email token parser for FTS