sails-postgresql 连接到 Docker 容器中运行的数据库时"poolSize"错误太高

Question

我正在构建一个新的Sails.js应用程序，该应用程序连接到PostgreSQL数据库。在我使用sails generate model products创建一个新模型之前，应用程序一直运行得很好。当应用程序尝试启动时，我现在遇到以下错误：

server_1      | [nodemon] starting `node app.js`
server_1      |  info: ·• Auto-migrating...  (alter)
server_1      |  info:    Hold tight, this could take a moment.
server_1      | Troubleshooting tips:
server_1      |
server_1      |  -> Is your Postgresql configuration correct?  Maybe your `poolSize` configuration is set too high? e.g. If your Postgresql database only supports 20 concurrent connections, you should make sure you have your `poolSize` set as something < 20 (see http://stackoverflow.com/a/27387928/486547). The default `poolSize` is 10. To override default settings, specify the desired properties on the relevant Postgresql "connection" config object where the host/port/database/etc. are configured. If you're using Sails, this is generally located in `config/datastores.js`, or wherever your environment-specific database configuration is set.
server_1      |
server_1      |  -> Maybe your `poolSize` configuration is set too high? e.g. If your Postgresql database only supports 20 concurrent connections, you should make sure you have your `poolSize` set as something < 20 (see http://stackoverflow.com/a/27387928/486547). The default `poolSize` is 10.
server_1      |
server_1      |  -> Do you have multiple Sails instances sharing the same Postgresql database? Each Sails instance may use up to the configured `poolSize` # of connections. Assuming all of the Sails instances are just copies of one another (a reasonable best practice) we can calculate the actual # of Postgresql connections used (C) by multiplying the configured `poolSize` (P) by the number of Sails instances (N). If the actual number of connections (C) exceeds the total # of **AVAILABLE** connections to your Postgresql database (V), then you have problems.  If this applies to you, try reducing your `poolSize` configuration. A reasonable `poolSize` setting would be V/N.

为了响应这个错误，我在datastores.js文件中添加了一个poolSize密钥，如下所示：

module.exports.datastores = {
default: {
adapter: 'sails-postgresql',
url: 'postgresql://postgres@postgresql:5432/web-service',
poolSize: 1
},
};

它仍然抛出相同的错误。应用程序和数据库都在Docker环境中运行。这就是我的docker-compose.yml的样子：

version: '3.4'
services:
server:
image: web-service
build: .
environment:
NODE_ENV: development
IS_DEV_MACHINE: "yes"
ports:
- 1338:1337 # HOST_PORT is 1338 to avoid conflicts with other Sails.js apps running on host
volumes:
- ../:/usr/src/app
entrypoint: nodemon
postgresql:
image: bitnami/postgresql:9.6
ports:
- 5433:5432 # HOST_PORT is 5433 to avoid conflicts with other PostgreSQL instances running on host
volumes:
- ../database:/bitnami

我似乎在任何地方都找不到解决这个问题的办法。关于这个主题的其他StackOverflow线程已经一年多没有得到回复了。感谢您的帮助。

Answer 1

我通过从bitnami:postgresql:9.6 Docker映像切换到postgres:9.6来解决错误。显然postgres:9.6接受了100个连接(这似乎比Bitnami图片接受的要多(。即使我从datastores.js中删除了poolSize: 1，Sails也不再抛出poolSize错误

version: '3.4'
services:
server:
image: web-service
build: .
environment:
NODE_ENV: development
IS_DEV_MACHINE: "yes"
ports:
- 1338:1337 # HOST_PORT is 1338 to avoid conflicts with other Sails.js apps running on host
volumes:
- ../:/usr/src/app
entrypoint: nodemon
postgresql:
image: postgres:9.6
environment:
POSTGRES_USER: admin
POSTGRES_PASSWORD: admin
ports:
- 5433:5432 # HOST_PORT is 5433 to avoid conflicts with other PostgreSQL instances running on host
volumes:
- ../database:/var/lib/postgresql/data