How to restore / backup in Docker environment?

[knebb]

Hi,

currently I have Netbox up and running on a VM on my NAS.
But it is very slow and I have a server available with more power who offers Docker environment.

So I am thinking to migrate my "baremetal" installation to a Docker based Netbox. I guess this will be not a huge issue, right?

How do I restore my current configuratioj to the new docker image?

AND, even more important: How do I do a backup of the Netbox data from the docker instance?
(I knwo paperless-ngx and it has an exporter who simply writes all data to a drive on the host. I expected something like this on Docker Netbox- does it exist?

Thanks for ideas!

/KNEBb

[atxmstr]

Hi, You just need to back up the netbox db from the baremetal and dump it into the docker instance.
To back up:
/usr/local/bin/pg_dump --exclude-table-data extras_cachedvalue --exclude-table-data extras_objectchange $DB_NAME -U $DB_USER
| gzip -9 > netbox_db.gz
To restore use this bash script:
#!/bin/bash

Retrieve the running PostgreSQL container ID

CONTAINER_ID=$(docker ps | grep "postgres:17-alpine" | awk '{print $1}')

Define variables

DB_NAME="netbox"
DB_USER="netbox"
BACKUP_DIR="."
BACKUP_FILE= "netbox_db.gz"

Ensure we found a container ID

if [ -z "$CONTAINER_ID" ]; then
echo "Error: No PostgreSQL container found."
exit 1
fi

echo "Using container ID: $CONTAINER_ID"

Create new database inside the container

echo "Creating database inside Docker container..."
docker exec --user root $CONTAINER_ID createdb -O $DB_USER $DB_NAME

Decompress backup file outside the container

echo "Decompressing backup file..."
gunzip -c $BACKUP_FILE > netbox_db.sql

Copying database into the container

echo "Copying database into the container"
docker cp netbox_db.sql $CONTAINER_ID:/netbox_db.sql

Restore backup inside the container

echo "Restoring database..."
docker exec --user root $CONTAINER_ID psql -U $DB_USER -d $DB_NAME -f /netbox_db.sql

echo "Database restoration complete!"

I hope this helps :)