Database connection pool expiration

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Database connection pool expiration

Kuk Hyun Kim
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

Reply | Threaded
Open this post in threaded view
|

Re: Database connection pool expiration

Shreeyansh dba
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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: Database connection pool expiration

Kuk Hyun Kim
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 <[hidden email]> 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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: Database connection pool expiration

Shreeyansh dba
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Upgrade Moving Data

Ferrell, Denise SDC

Upgrading from RHEL5 Postgres v.9.5 to RHEL7 v10.3 on VMs.


While the database objects have been created on the new VM I'm having issues getting the data moved over.  I've tried a data only pg dump and restore it fails.


Any ideas as to how to accomplish this


Thank you in advance for any assistance,

Denise

Reply | Threaded
Open this post in threaded view
|

Re: Upgrade Moving Data

Shreeyansh dba
Hi Denise,

Can you share error how you did it and what issues you faced?

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


On Thu, Jan 10, 2019 at 3:03 PM Ferrell, Denise SDC <[hidden email]> wrote:

Upgrading from RHEL5 Postgres v.9.5 to RHEL7 v10.3 on VMs.


While the database objects have been created on the new VM I'm having issues getting the data moved over.  I've tried a data only pg dump and restore it fails.


Any ideas as to how to accomplish this


Thank you in advance for any assistance,

Denise