Re: problem during postgres restore: max_connections = 100 is a lower setting than on the primary server, where its value was 350

pooling is a good point.

Regards,

Fabrice

On Mon, Mar 2, 2026 at 6:42 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Mon, 2026-03-02 at 17:13 +0100, Fabrice Chapuis wrote:
> > I think the value of max_connections must be aligned with primary because
> > the goal is to maintain this sizing in case of a failover and promotion
> of the standby.
>
> Not every standby is for failover.
> The technical reason is that the process array on the standby has to be at
> least
> as big as on the primary (if you are setting "hot_standby = on").
>
> > Why to be conservative with `max_connection` and not with shared buffer?
> > If we're performing recovery on a machine with significantly fewer CPU
> and RAM
> > resources than the original server, lowering these parameters could be
> an option
> > because they reserve memory at starting.
>
> Perhaps, but you cannot do it. If that is a requirement, use a connection
> pool.
>
> Yours,
> Laurenz Albe
>