Database Administration

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 \# 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 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 \# 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