backup

`pg_dump dbname > dumpfile https://www.postgresql.org/docs/current/backup-dump.html

pg_dump -h $DBHOST -p $DBPORT -U $DBUSER --format=p --clean -d $DBNAME > /var/lib/backup/$DBNAME.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/backup.tpl

pg_dump -h localhost -p 5432 -U firefly --format=p --clean -d firefly > /db-bcp/firefly.sql

restore

`psql dbname < dumpfile https://www.postgresql.org/docs/current/backup-dump.html

psql -h $DBHOST -p $DBPORT -U $DBUSER < /var/lib/backup/${DBNAME}.sql https://github.com/firefly-iii/kubernetes/blob/main/charts/firefly-db/templates/firefly-db-restore-job.yml

psql -h localhost -p 5432 -U firefly < /var/lib/postgresql/data/firefly.sql

and maybe run this on the core (NOT the db)

php artisan firefly-iii:correct-database