Database Administration

4min

Copy SQLite database locally
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
|
# List all pods in 'microtica' namespace. Replace the namespace if you deployed the service in namespace other then the default 'microtica' namespace.
kubectl get pods -n microtica

# Copy SQLite database locally
kubectl cp microtica/<pod name>:/home/node/.n8n/database.sqlite ~/database.sqlite
# List all pods in 'microtica' namespace. Replace the namespace if you deployed the service in namespace other then the default 'microtica' namespace.
kubectl get pods -n microtica

# Copy SQLite database locally
kubectl cp microtica/<pod name>:/home/node/.n8n/database.sqlite ~/database.sqlite
﻿
This command will copy the SQLite database locally to ~/database.sqlite.
Connect to Postgres database
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
|
kubectl get pods -n microtica
kubectl get pods -n microtica
﻿
Next, establish a proxy to the n8n pod running the Postgres database by executing the following command in the terminal:
Shell
|
# Change <pod name> to the name of the Pod
# Use different local port if 5432 is already in use. E.g. 5444:5432
kubectl port-forward pods/<pod name> 5432:5432 -n microtica
# Change <pod name> to the name of the Pod
# Use different local port if 5432 is already in use. E.g. 5444:5432
kubectl port-forward pods/<pod name> 5432:5432 -n microtica
﻿
Now, you can conveniently access the database using your preferred client on localhost:5432.

Updated 26 Jul 2023

Did this page help you?

Import an existing n8n application

Next.js

Docs powered by

Archbee

TABLE OF CONTENTS

Copy SQLite database locally

Connect to Postgres database