Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Postgresql TCP keepalive settings must match production needs #2784

Open
acozine opened this issue Feb 23, 2022 · 1 comment · May be fixed by #3333
Open

Postgresql TCP keepalive settings must match production needs #2784

acozine opened this issue Feb 23, 2022 · 1 comment · May be fixed by #3333
Assignees
@acozine

Comments

@acozine
Copy link
Contributor

acozine commented Feb 23, 2022

Related to pulibrary/bibdata#1531 and pulibrary/bibdata#1514.
Supersedes #2359.
Also related to #2735 and #2782.

Recently we've seen bibdata connections failing on long-running processes. Adjust keepalive settings to allow these processes to complete while the connections are still live.

# Adjust keepalives so that connections don't die on long-running processes.
tcp_keepalives_count = 10
tcp_keepalives_idle = 30
tcp_keepalives_interval = 30
@acozine acozine mentioned this issue Feb 23, 2022
Closed
@acozine
Copy link
Contributor Author

acozine commented Sep 15, 2022

Related to #2305

@acozine acozine self-assigned this Sep 15, 2022
@acozine acozine linked a pull request Sep 16, 2022 that will close this issue
Draft
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@acozine acozine

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

adds keepalive values to postgresql config pulibrary/princeton_ansible
1 participant
@acozine