Re: Removing max_connection requirement on hot_standby

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Chris Winslett <chris(at)compose(dot)io>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Removing max_connection requirement on hot_standby
Date: 2015-09-30 16:36:22
Message-ID: 560C0F86.7060104@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/30/2015 04:31 AM, Chris Winslett wrote:
> I'm orchestrating Postgres to behave as a leader-follower cluster. I've run
> into issues when I am scaling down a connection count for a cluster
> (scaling up is fine -- scaling down results in fatal errors). I use an
> open source tool I've written to orchestrate the cluster called Governor (
> http://github.com/compose/governor). It would work if I weren't running
> hot_standby, but alas…I'm running with it.
>
> I found the code which throws the fatal is actually a pre-flight test for
> hot_standby written in 2009 (i.e. battle tested):
>
> https://github.com/postgres/postgres/blob/efc16ea520679d713d98a2c7bf1453c4ff7b91ec/src/backend/access/transam/xlog.c#L5312-L5321
>
> I've tested changing this value from a FATAL to a WARN. I've compiled and
> tested my scenario and all appears to be correct:
>
> https://github.com/compose/postgres/commit/2bdf6b36821987aadb401e1b8590ecc5b02126d8

It will work, until you actually have more active transactions in the
master than you have slots available in the standby.

- Heikki

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-09-30 16:41:49 Re: Removing max_connection requirement on hot_standby
Previous Message Joshua D. Drake 2015-09-30 16:26:15 Re: No Issue Tracker - Say it Ain't So!