Ready-to-use Templates
n8n Workflow Automation
Database Administration
4min
To copy the n8n SQLite database from the cloud to your local environment, start by configuring the Kubernetes cluster access.
Next, run the following commands in your terminal:
Shell
|
īģŋ
This command will copy the SQLite database locally to ~/database.sqlite.
For the n8n application, the Postgres database runs in a separate container.
To connect with the database locally, you first need to identify the pod running the Postgres database using the following command:
Shell
|
īģŋ
Next, establish a proxy to the n8n pod running the Postgres database by executing the following command in the terminal:
Shell
|
īģŋ
Now, you can conveniently access the database using your preferred client on localhost:5432.
Updated 26 Jul 2023
Did this page help you?