| From: | Sudhir Guna <sudhir(dot)guna(dot)sg(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | DB connection issue suggestions |
| Date: | 2022-05-10 16:59:01 |
| Message-ID: | CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Dear All,
We have recently upgraded Postgresql 9.4 standalone server to Postgresql
11.2 with High Availability (2 servers : Master and Standby).
While trying to test using ETL applications and reports, we observe that
the ETL jobs fails with below error,
2022/05/06 16:27:36 - Error occurred while trying to connect to the database
2022/05/06 16:27:36 - Error connecting to database: (using class
org.postgresql.Driver)
2022/05/06 16:27:36 - FATAL: Sorry, too many clients already
We have increased the max_connections = 1000 in postgresql.conf file.
It worked ok for a day and later we get the same error message.
Please help to advise on any additional settings required. The prior
Postgresql 9.4 had the default max_connections = 100 and the applications
worked fine.
Regards,
Guna
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MichaelDBA Vitale | 2022-05-10 18:13:14 | Re: DB connection issue suggestions |
| Previous Message | Tom Lane | 2022-05-05 02:08:59 | Re: Why is there a Sort after an Index Only Scan? |