为什么在 docker (ubuntu:18.04) 中运行长时间运行的 postgres 查询需要 `psycopg2.connect(...)` 中的 `keepalives` 参数？

发布于 2025-01-11 11:26:25 字数 1299 浏览 0 评论 0原文

我们刚刚过渡到使用 Docker 进行开发，并使用 ubuntu:18.04 映像。我们注意到使用 psycopg2 的查询在几分钟后失败。这个答案使用以下 keepalives 参数解决了问题：

self.db = pg.connect(
    dbname=config.db_name,
    user=config.db_user,
    password=config.db_password,
    host=config.db_host,
    port=config.db_port,
    keepalives=1,
    keepalives_idle=30,
    keepalives_interval=10,
    keepalives_count=5
)

这也适用于我们，但是为什么这有效？ psycopg2 文档没有深入了解参数的作用，这第三个party 文档确实如此，并且此 postgres 文档确实如此。

问题是，docker 环境与主机环境有何不同，导致需要这些非默认设置？它们也可以在标准 Ubuntu 18.04 环境中工作，但不能在 docker 中工作。我希望我们可以重新配置我们的 docker 映像，以便首先不需要这些非标准参数。

Postgres版本：x86_64-pc-linux-gnu上的PostgreSQL 13.4 (Ubuntu 13.4-1.pgdg20.04+1)，由gcc编译(Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0，64位< /code>

psycopg2 版本：2.8.5

主机操作系统：Windows 10

Docker图像操作系统：Ubuntu 18:04

原文

We just transitioned to using Docker for development and are using the ubuntu:18.04 image. We noticed that queries using psycopg2 failed after a few minutes. This answer solved the problem using the following keepalives params:

self.db = pg.connect(
    dbname=config.db_name,
    user=config.db_user,
    password=config.db_password,
    host=config.db_host,
    port=config.db_port,
    keepalives=1,
    keepalives_idle=30,
    keepalives_interval=10,
    keepalives_count=5
)

This works for us as well, but why does this work? The psycopg2 docs do not give insight into what the params do, however, this third party documentation does, and this postgres documentation does.

The question is, what is different in the docker environment vs the host environment which makes these non-default settings required? They work in a standard Ubuntu 18.04 environment too, but not in docker. I am hoping we could reconfigure our docker image so that these non-standard parameters aren't necessary in the first place.

Postgres version: PostgreSQL 13.4 (Ubuntu 13.4-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit

psycopg2 version: 2.8.5

Host OS: Windows 10

Docker Image OS: Ubuntu 18:04

分享到QQ

分享到微博