Per a recuperar de un pg_dump
https://docs.pleroma.social/backend/administration/backup/
Create database, user, and extensions
su postgres -s $SHELL -lc "psql -f /tmp/setup_db.psql"
Delete the database (it’s empty)
su postgres
dropdb pleroma
Restore the backup.
pg_restore -C -d postgres pleroma_backup.sql.dump
exit
Run migrate.
su pleroma -s $SHELL -lc "./bin/pleroma_ctl migrate"
Més info postgres
https://www.postgresql.org/docs/12/app-pgrestore.html Veanse “Examples”