I have setup n8n as linux service with postgress as Db, but when i try to import the workflows it says successful, but there is records added in the Db

[Vijay_Madan]

I have setup n8n as linux service with postgress as Db, but when i try to import the workflows from terminale it says successful, but there is records added in the sqllite not postgress

What is the error message (if any)? NO ERROR

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

• 0.230.3:
• **Postgress
• main
• *AWS ec2
• Operating system:

[Jon]

Hey @Vijay_Madan,

Welcome to the community

It sounds like it is not correctly configured to use Postgres, Can you share more on your setup so we can see if we can work out what is missing?

[Vijay_Madan]

Install n8n - Open Source Workflow Automation - on Linux

I have followed this blog i have used postgress instead of mysql

[Jon]

Hey @Vijay_Madan,

Can you share the actual settings you used with replacement values for anything sensitive? That guide on its own would likely work but it isn’t one of ours and it doesn’t tell me which settings you have actually used.

[Vijay_Madan]

[Unit]
Description=n8n
After=postgresdb.service

[Service]
User=root
Group=root
Environment=DB_TYPE=postgresdb
Environment=DB_POSTGRESDB_DATABASE=n8nnew
Environment=DB_POSTGRESDB_HOST=localhost
Environment=DB_POSTGRESDB_USER=n8n
Environment=DB_POSTGRESDB_PASSWORD=n8n
Environment=GENERIC_TIMEZONE=America/New_York
Environment=WEBHOOK_URL=https://examplecom/
Environment=WEBHOOK_TUNNEL_URL=https://examplecom/
Environment=N8N_ENDPOINT_WEBHOOK=“prod/v1”
#Environnment=EXECUTIONS_PROCESS=main
Environtment=EXECUTIONS_DATA_PRUNE=true
Environtment=EXECUTIONS_DATA_MAX_AGE=168
Environtment=EXECUTIONS_DATA_PRUNE_MAX_COUNT=50000
Environment=N8N_USER_FOLDER=/home/ubuntu/n8n/
ExecStart=n8n
WorkingDirectory=/usr/bin

[Install]
WantedBy=multi-user.target

[Jon]

Hey @Vijay_Madan,

Does your webhook url look correct in the UI or does it show as localhost? There are also a couple of typos for the execution data options with an extra t in environment.

I would probably try starting from a terminal with the env options and see if that works.