Re: Database connection pool expiration

How are you connecting to the Database? What message you get?

If you are using the middleware (like pgbouncer or pgpool-II) for
connections, These tools also have its own connection timeout parameter
settings.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Mon, Jan 7, 2019 at 12:36 PM Calvin Kim <khk800123(at)gmail(dot)com> wrote:

> Hi,
>
> I have checked both and they were all commented out, so they were disabled.
>
> Could there be some other db config to check for?
>
> Thanks.
> Calvin
>
> Sent from my iPhone
>
> On 7 Jan 2019, at 6:01 pm, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> wrote:
>
> There may be several performance factors which might be causing the DB
> connection expired before completing long running transactions. However,
> you can consider tweaking statement_timeout and
> idle_in_transaction_session_timeout parameter.
>
> Thanks & Regards,
> *Shreeyansh DBA Team*
> www.shreeyansh.com
>
>
> On Mon, Jan 7, 2019 at 9:32 AM Kuk Hyun Kim <khk800123(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> Recently, developers are saying that the DB connection is getting
>> expired causing issue while running long transactions.
>>
>> Is there a such configuration setting in Postgres and what would be
>> the default and recommended value for this?
>>
>> Regards,
>> Calvin
>>
>>