Please fill in the questionnaire below.
Technical Help Questionnaire
Answer: Yes
How have you self-hosted Baserow.
Docker - Portainer on a Synology NAS following exact instructions on How to Install Baserow on Your Synology NAS – Marius Hosting
I also had an instance running on a Raspberry Pi that i installed using the Quick Start installation guide here. This was my very first project using Docker, so it was a combined ‘experience’.
What are the specs of the service or server you are using to host Baserow.
Which version of Baserow are you using.
on Synology nas, baserow:1.19.1
on Raspberry pi, baserow: 1.21.2
How have you configured your self-hosted installation?
See above
I am very much a noobie when it comes to Docker and self hosting. I discovered Baserow about 1 month ago and set it up on a Raspberry Pi in order to move away from Airtable and secure my own data.
I recently purchased a NAS and went about installing docker and portainer on it following guides on Marius Hosting website (see above). I want to migrate the baserow 'installation? container? database? whatever its called from the Rasperry pi over to the Synology Nas and have been so frustrated with the process as nothing i do seems to work. I have tried doing a full backup and restore and also tried doing the backup/restore of just the db as described here: Install with Docker // Baserow
Can someone please point me in the right direction or give me step by step advise?
The Baserow I want to restore to was configured with the following:
version: "3.9"
services:
redis:
image: redis
command:
- /bin/sh
- -c
- redis-server --requirepass redispass
container_name: Baserow-REDIS
hostname: baserow-redis
mem_limit: 256m
mem_reservation: 50m
cpu_shares: 768
security_opt:
- no-new-privileges:true
read_only: true
user: 1026:100
healthcheck:
test: ["CMD-SHELL", "redis-cli ping || exit 1"]
volumes:
- /volume1/docker/baserow/redis:/data:rw
environment:
TZ: Europe/Bucharest
restart: on-failure:5
db:
image: postgres
container_name: Baserow-DB
hostname: baserow-db
mem_limit: 512m
cpu_shares: 768
security_opt:
- no-new-privileges:true
user: 1026:100
healthcheck:
test: ["CMD", "pg_isready", "-q", "-d", "baserow", "-U", "baserowuser"]
timeout: 45s
interval: 10s
retries: 10
volumes:
- /volume1/docker/baserow/db:/var/lib/postgresql/data:rw
environment:
POSTGRES_DB: baserow
POSTGRES_USER: baserowuser
POSTGRES_PASSWORD: baserowpass
restart: on-failure:5
baserow:
image: baserow/baserow:1.19.1
container_name: Baserow
hostname: baserow
mem_limit: 3g
cpu_shares: 768
security_opt:
- no-new-privileges:true
read_only: true
ports:
- 3888:80
volumes:
- /volume1/docker/baserow/data:/baserow/data:rw
environment:
BASEROW_PUBLIC_URL: https://baserow.somewhere.selfhosted
BASEROW_MAX_IMPORT_FILE_SIZE_MB: 1024
DATABASE_USER: baserowuser
DATABASE_PASSWORD: baserowpass
DATABASE_NAME: baserow
DATABASE_HOST: baserow-db
DATABASE_PORT: 5432
REDIS_HOST: baserow-redis
REDIS_PORT: 6379
REDIS_PROTOCOL: redis
REDIS_USER: default
REDIS_PASSWORD: redispass
EMAIL_SMTP: my email
EMAIL_SMTP_HOST: my email
EMAIL_SMTP_PORT: 587
EMAIL_SMTP_USER: my email
EMAIL_SMTP_PASSWORD: my email
EMAIL_SMTP_USE_TLS: true
FROM_EMAIL: my email
restart: on-failure:5
depends_on:
redis:
condition: service_healthy
db:
condition: service_healthy
and the original baserow was built using
version: "3.4"
services:
baserow:
container_name: baserow
image: baserow/baserow:1.22.1
environment:
BASEROW_PUBLIC_URL: 'http://localhost'
ports:
- "80:80"
- "443:443"
volumes:
- baserow_data:/baserow/data
volumes:
baserow_data:
and both backups (Full Baserow backup AND just DB backup)
docker run --rm -v baserow_data:/baserow/data -v $PWD:/backup ubuntu tar cvf /backup/backup.tar /baserow/data
and
docker run -it --rm -v baserow_data:/baserow/data baserow/baserow:1.22.1 \
backend-cmd-with-db backup -f /baserow/data/backups/backup.tar.gz
The paths to the baserow containers in my Synology NAS is
\volume1\docker\baserow
\volume1\docker\db
\volume1\docker\redis
and the backup files are both at:
\volume1\Documents
I really am a bit lost now. Can someone please help me with building the correct command to restore from the backup to the Synology NAS?
