Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir
← Toutes les solutions

OpenMU in Docker: how do I back up and restore the PostgreSQL database, and fix 'permission denied for schema config' after a restore?

Rédigé par MuADMINS à partir de la sourceNot verified

Outil : openmu-docker (nolt)

  1. The openmu-db-backup container of nolt/openmu-docker runs pg_dump -Fc every BACKUP_INTERVAL seconds (default 86400), checks the dump and keeps gzipped files in ./backups/ for RETENTION_DAYS (default 7). A manual run: docker exec openmu-db-backup /usr/local/bin/backup.sh.
  2. To restore, stop only the game server: docker compose stop openmu (never down -v, which deletes the data volume).
  3. Restore: gunzip -c backups/openmu_YYYYMMDD_HHMMSS.dump.gz | docker exec -i openmu-postgres pg_restore --clean --if-exists -U postgres -d openmu, then docker compose start openmu.
  4. Check it: SELECT count(*) FROM data."Account"; SELECT count(*) FROM config."GameConfiguration"; must give your account count and 1. A missing GameConfiguration makes the server initialize again.
  5. *permission denied for schema config* or 28P01 at startup happens after a restore into a fresh, empty Postgres cluster: the login roles config, account, guild and friend are not in the dump. Create them (role name = password) and grant them the schemas with the SQL block from the README, then start the server.
Cela vous a-t-il aidé ?

Toujours bloqué ? Rechercher sur MuGPS Demander à l'Assistant MU

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.