Unable to use Postgres Database, Environment Variable Configuration Error

this is my first time using postgres database isntead of Sqlite and im using digital ocean’s managed database postgres service. I was trying to set the environment variables up in the Yml file but the logs seem to say that there was an issue with the SSL and im also unable to visit the site of where im supposed to be able to access n8n. This is a picture of the yml file with the environment variables placed in including the certificate file from digital ocean. did i miss something? why can’t i access my self hosted n8n and why cant it connect with the postgres databse. Thank you!

image

Information on your n8n setup

  • **n8n version:**Latest
  • Database (default: SQLite): Trying To Set Up PostgresSQL (digital ocean)
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**default
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker (Digital Ocean Droplet)
  • **Operating system:**Ubuntu

Hey @Andres_Rafael

Can you try making sure that the mounted certificate volume is owned by node:node and see if that helps.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.