Database Administration

copy sqlite database locally to copy the n8n sqlite database from the cloud to your local environment, start by https //docs microtica com/eks administration#oqdng 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