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?
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:
