pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
4+ messages / 4 participants
[nested] [flat]
* BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
@ 2022-08-03 10:09 PG Bug reporting form <noreply@postgresql.org>
2022-08-03 11:13 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: PG Bug reporting form @ 2022-08-03 10:09 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: poornima3230@gmail.com
The following bug has been logged on the website:
Bug reference: 17567
Logged by: Poornima Venkatesan
Email address: poornima3230@gmail.com
PostgreSQL version: 12.10
Operating system: Windows/Linux
Description:
Hi Team,
PostgreSQL in Production environment is configured using primary and
secondary DB servers via Patroni. We have requirement to explicitly to set
Max_Connection as 300 overriding default value. If we set Max_Connections in
postgresql.config, its getting reset post restart of Patroni.
Please advise us on the steps on how to configure and set Max_Connections in
Replica DB servers.
Thanks & Regards,
Poornima V
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
2022-08-03 10:09 BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form <noreply@postgresql.org>
@ 2022-08-03 11:13 ` Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
2022-08-03 19:17 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Poornima Venkatesan <poornima3230@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Juan José Santamaría Flecha @ 2022-08-03 11:13 UTC (permalink / raw)
To: poornima3230@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Wed, Aug 3, 2022 at 12:48 PM PG Bug reporting form <
noreply@postgresql.org> wrote:
>
> Please advise us on the steps on how to configure and set Max_Connections
> in
> Replica DB servers.
>
This list is meant for reporting bugs only, please send questions like so
to pgsql-general@lists.postgresql.org.
Regards,
Juan José Santamaría Flecha
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
2022-08-03 10:09 BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form <noreply@postgresql.org>
2022-08-03 11:13 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
@ 2022-08-03 19:17 ` Poornima Venkatesan <poornima3230@gmail.com>
2022-08-04 08:32 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Mateusz Henicz <mateuszhenicz@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Poornima Venkatesan @ 2022-08-03 19:17 UTC (permalink / raw)
To: Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>; pgsql-general@lists.postgresql.org
Hi Team,
PostgreSQL in our Production environment is configured using primary and
secondary DB servers via Patroni. We have requirement to explicitly to set
Max_Connection as 300 overriding default value. If we set Max_Connections in
postgresql.config, it is getting reset post restart of Patroni.
Please advise us on the steps on how to configure and set Max_Connections in
Replica DB servers.
Thanks & Regards,
Poornima V
On Wed, Aug 3, 2022 at 4:43 PM Juan José Santamaría Flecha <
juanjo.santamaria@gmail.com> wrote:
>
> On Wed, Aug 3, 2022 at 12:48 PM PG Bug reporting form <
> noreply@postgresql.org> wrote:
>
>>
>> Please advise us on the steps on how to configure and set Max_Connections
>> in
>> Replica DB servers.
>>
>
> This list is meant for reporting bugs only, please send questions like so
> to pgsql-general@lists.postgresql.org.
>
> Regards,
>
> Juan José Santamaría Flecha
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas
2022-08-03 10:09 BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form <noreply@postgresql.org>
2022-08-03 11:13 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
2022-08-03 19:17 ` Re: BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas Poornima Venkatesan <poornima3230@gmail.com>
@ 2022-08-04 08:32 ` Mateusz Henicz <mateuszhenicz@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Mateusz Henicz @ 2022-08-04 08:32 UTC (permalink / raw)
To: Poornima Venkatesan <poornima3230@gmail.com>; +Cc: Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>; pgsql-general@lists.postgresql.org
Hey,
It is not a bug.
If you are using patroni, you should change your parameters in patroni
configuration yaml file, so the changes are reflected in your Distributed
Configuration Store. If you would look at the Patroni documentation (
https://patroni.readthedocs.io/en/latest/SETTINGS.html) you can find a
note, that parameters like max_connections are stored in DCS and applied on
all Patroni nodes overwriting settings from postgresql.conf. Also if
Postgres was bootstrapped by Patroni, postgresql.conf itself should have a
note:
# Do not edit this file manually!
# It will be overwritten by Patroni!
Hope it helps.
Cheers,
Mateusz
czw., 4 sie 2022 o 10:21 Poornima Venkatesan <poornima3230@gmail.com>
napisał(a):
>
> Hi Team,
>
> PostgreSQL in our Production environment is configured using primary and
> secondary DB servers via Patroni. We have requirement to explicitly to set
> Max_Connection as 300 overriding default value. If we set Max_Connections
> in
> postgresql.config, it is getting reset post restart of Patroni.
>
> Please advise us on the steps on how to configure and set Max_Connections
> in
> Replica DB servers.
>
> Thanks & Regards,
> Poornima V
>
>
> On Wed, Aug 3, 2022 at 4:43 PM Juan José Santamaría Flecha <
> juanjo.santamaria@gmail.com> wrote:
>
>>
>> On Wed, Aug 3, 2022 at 12:48 PM PG Bug reporting form <
>> noreply@postgresql.org> wrote:
>>
>>>
>>> Please advise us on the steps on how to configure and set
>>> Max_Connections in
>>> Replica DB servers.
>>>
>>
>> This list is meant for reporting bugs only, please send questions like so
>> to pgsql-general@lists.postgresql.org.
>>
>> Regards,
>>
>> Juan José Santamaría Flecha
>>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-08-04 08:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-03 10:09 BUG #17567: Unable to Set Max_Connection in Postgresql which has replicas PG Bug reporting form <noreply@postgresql.org>
2022-08-03 11:13 ` Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
2022-08-03 19:17 ` Poornima Venkatesan <poornima3230@gmail.com>
2022-08-04 08:32 ` Mateusz Henicz <mateuszhenicz@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox