Can I connect to PostgreSQL using this command?

Questions
1

"Hello everyone, could you please tell me if I can connect to a PostgreSQL database using this command: export N8N_POSTGRESDB_URL=postgres://username:password@host:port/database

3

Hey @Gregory_Li,

Welcome to the community :tada:

That isn’t an option we support, You can find the valid env options here: Environment variables reference | n8n Docs

Based on your connection string example you would need…

export DB_TYPE=postgresdb
export DB_POSTGRESDB_USER=username
export DB_POSTGRESDB_PASSWORD=password
export DB_POSTGRESDB_HOST=host
export DB_POSTGRESDB_PORT=port
export DB_POSTGRESDB_DATABASE=database
1 Like
4

Sorry for the silly question, thank you for your response. Its work

1 Like
5

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