Describe the problem/error/question
Hello everybody! I’m testing n8n locally, and i’ve been some gaps in my configuration.
First, i’m running project:
pnpm build; pnpm start;
And running postgres with docker, like this:
docker run -p 5432:5432 -v /tmp/database:/var/lib/postgresql/data -e POSTGRES_PASSWORD=1234 -d postgres
And, my question is: how i see database infos? I’m using beekeeper, and idk how i connect to a database that n8n use to save infos. My connection infos is:
When i run test connection, everything is ok! But, don’t have data of n8n! What is missing from the configuration process?
I know that this question is a little… dumb. I realized that I dont need to run docker postgres, but, i keep my first question, how i can see data in db?
Hi @trickaugusto, welcome to the community!
So there’s two aspects to your questions. The first being about not seeing any n8n data in PostgreSQL. This will be because n8n uses a SQLite database file by default (the
database.sqlite file in the
~/.n8n directory). If you’d rather have n8n use your PostgreSQL database you’d need to set the
DB_TYPE=postgresdb environment variable as well as the other PostgreSQL-specific environment variables.
To see the data living in the default SQLite database you can simply open it using Beekeeper Studio like so:
You should then see the full database structure used by n8n:
Hope this helps
Let me know if you run into any trouble with this.
Everything ok! I kept sqlite.
Thank you for your help! =)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.