1
Postgres Unit Socket Support
Source: outline/outline#6272 · opened by @98h398hrpohpoai
Is it possible to add support for postgres unix sockets?
They generally tend to provide better security and performance.
It appears it was previously possible with [ however, this workaround no longer works as sequelize produces errors without a DATABASE_URL variable, and does not pass the socket through properly with it.
Passing through a socket via something like postgres://outline:password@/outline?host=/run/postgresql treats it as a tcp connection with the following error despite being supported syntax:
ERROR: connect ECONNREFUSED 127.0.0.1:5432
Edit: This is addressed more thoroughly below, but the error with my attempt above is not specifying the host and port despite providing the socket config.
Specifying these variables alters how the postgres connector searches for the socket in the case of non-standard configuration i.e. anything other than localhost:5432, which would be the container itself.
They generally tend to provide better security and performance.
It appears it was previously possible with [ however, this workaround no longer works as sequelize produces errors without a DATABASE_URL variable, and does not pass the socket through properly with it.
Passing through a socket via something like postgres://outline:password@/outline?host=/run/postgresql treats it as a tcp connection with the following error despite being supported syntax:
ERROR: connect ECONNREFUSED 127.0.0.1:5432
Edit: This is addressed more thoroughly below, but the error with my attempt above is not specifying the host and port despite providing the socket config.
Specifying these variables alters how the postgres connector searches for the socket in the case of non-standard configuration i.e. anything other than localhost:5432, which would be the container itself.
No pledges yet. Be the first to back this.
Comments
Similar requests
support systemd socket activation
1 vote · 0 comments
[Urgent] Example Docker self-hosting config exposes Postgres/Redis to the Internet
1 vote · 0 comments
Add more options for launching a self-hosted web server
1 vote · 0 comments
Auto backup functionality
1 vote · 0 comments
Uploading or embed pdfs
12 votes · 0 comments
No comments yet.