使用 Node.js 时设置连接超时
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
使用 Node.js knex 模块连接到 Cloud SQL for PostgreSQL 时配置连接超时。
深入探索
如需查看包含此代码示例的详细文档,请参阅以下内容:
代码示例
Node.js
如需向 Cloud SQL for PostgreSQL 进行身份验证,请设置应用默认凭据。如需了解详情,请参阅为本地开发环境设置身份验证。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],[],[],[],null,["# Set the connection timeout when using Node.js\n\nConfigure a connection timeout when connecting to Cloud SQL for PostgreSQL by using the Node.js knex module.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Manage database connections](/sql/docs/postgres/manage-connections)\n\nCode sample\n-----------\n\n### Node.js\n\n\nTo authenticate to Cloud SQL for PostgreSQL, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n // 'acquireTimeoutMillis' is the number of milliseconds before a timeout occurs when acquiring a\n // connection from the pool. This is slightly different from connectionTimeout, because acquiring\n // a pool connection does not always involve making a new connection, and may include multiple retries.\n // when making a connection\n config.pool.acquireTimeoutMillis = 60000; // 60 seconds\n // 'createTimeoutMillis` is the maximum number of milliseconds to wait trying to establish an\n // initial connection before retrying.\n // After acquireTimeoutMillis has passed, a timeout exception will be thrown.\n config.pool.createTimeoutMillis = 30000; // 30 seconds\n // 'idleTimeoutMillis' is the number of milliseconds a connection must sit idle in the pool\n // and not be checked out before it is automatically closed.\n config.pool.idleTimeoutMillis = 600000; // 10 minutes\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_postgres)."]]