Re: Database connection pool expiration

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Database connection pool expiration
Дата
Msg-id CAGDYbUOm-oVW7oOQCLq8j5FVS9K_Q2eGCP5NfC-DWGrKg_JMhg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Database connection pool expiration  (Calvin Kim <khk800123@gmail.com>)
Ответы Upgrade Moving Data  ("Ferrell, Denise SDC" <denise.ferrell@sdc-world.com>)
Список pgsql-admin
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@gmail.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@gmail.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@gmail.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: Patroni on top of already existing clusters or replications
Следующее
От: Robert Simmons
Дата:
Сообщение: Re: postgres installation issue