# install CLI (one-time)pnpmadd-gn8n@next# to update to latest versionpnpmupdate-gn8n@next
Start
To start n8n with PostgreSQL simply start docker-compose by executing the following command in the current folder.
[!IMPORTANT]
But before you do, copy .env.example as .env in the project root directory, then change the default postgres username and password in the .env file, if you prefer.
# for first timedockercompose--profilefirst-time-onlyup# for next timedockercomposeup# if you want to ssh to n8n container dockercomposeexec-itn8nsh
Access n8n dashboard at:
Access qdrant dashboard at:
[!NOTE]
First time when you access, you will see: Set up owner account page. Enter some fake data, then you will be redirected to Dashboard
To Stop
Configuration
The default name of the database, user and password for PostgreSQL can be changed in the .env file in the current directory.
For Mac users running OLLAMA locally
If you're running Ollama locally on your Mac (not in Docker), make sure OLLAMA_HOST environment variable set to host.docker.internal:11434 in the n8n service configuration in compose.yaml .
open https://qdrant.agentic.orb.local/dashboard#/welcome
docker compose down
# DANGER: if you want stop and also want to remove all data, to reset database:
docker compose down -v
# First export env. NOTE: adjust db username/password as needed
export DB_TYPE=postgresdb DB_POSTGRESDB_HOST=localhost DB_POSTGRESDB_PORT=5432 DB_POSTGRESDB_DATABASE=n8n DB_POSTGRESDB_USER=user_postgres DB_POSTGRESDB_PASSWORD=user_password
# Export all the credentials to a specific directory using the --backup flag (details above):
n8n export:credentials --backup --output=config/n8n/credentials/
# Export all the credentials in plain text format.
n8n export:credentials --backup --decrypted --output=config/n8n/credentials/
# Import all the credentials files as JSON from the specified directory:
n8n import:credentials --separate --input=config/n8n/credentials/
# Export all your workflows to the standard output (terminal):
n8n export:workflow --all
# Export all the workflows to a specific directory using the --backup flag (details above):
n8n export:workflow --backup --output=config/n8n/workflows/
# Import all the workflow files as JSON from the specified directory:
n8n import:workflow --separate --input=config/n8n/workflows/