Re: DB connection issue suggestions

2022-05-10 Thread Anbazhagan M
Dear team, Can you confirm whether, post upgrade activity, all the post-upgrade steps including stats update on all the relations is complete. Upgrade doesn’t carry over the stats to the new upgraded cluster. Regards, Anbazhagan M > On 11-May-2022, at 11:43 AM, Laurenz Albe wrote: > > On Wed

Re: DB connection issue suggestions

2022-05-10 Thread Laurenz Albe
On Wed, 2022-05-11 at 00:59 +0800, Sudhir Guna wrote: > 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

Re: DB connection issue suggestions

2022-05-10 Thread Ranier Vilela
Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna escreveu: > 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 E

Re: DB connection issue suggestions

2022-05-10 Thread Justin Pryzby
On Wed, May 11, 2022 at 12:59:01AM +0800, Sudhir Guna wrote: > 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

Re: DB connection issue suggestions

2022-05-10 Thread MichaelDBA Vitale
Please show output of "show max_connections" to validate your assumptions. On 05/10/2022 12:59 PM Sudhir Guna wrote: Dear All, We have recently upgraded Postgresql 9.4 standalone server to Postgres

DB connection issue suggestions

2022-05-10 Thread Sudhir Guna
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 whi