How to connect redshift db using postgres connection

Describe the problem/error/question

I have n8n hosted in my VPS, and I want to connect to redshift database. Since there is no redshift node, I am trying to achieve this using postgres node. I could not find any detailed explanation on the same. Could you please help me?

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system: