Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

2 solutions for “postgres backup” · Clear

  1. Server setupOpenMU

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

    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...

    MuADMINS rewrite of the sourceNot verifiedGitHub (nolt/openmu-docker) · 2026-10-24
  2. Server setupOpenMUS6E3

    OpenMU in Docker: how do I update to a new version without losing accounts and characters?

    1. Back up the PostgreSQL database first. 2. In the folder with the compose file run docker-compose pull to pull all images of the stack. 3. Run docker-compose up -d. Containers that use...

    MuADMINS rewrite of the sourceNot verifiedGitHub (MUnique/OpenMU) · 2024-07-19

Matches for some of your words

These solutions have some of the words of “postgres backup”:

  1. Tools

    MFS Database Tool: the backup gives the same error as other backup managers, even with (local), Windows authentication or 127.0.0.1

    1. Connect to your SQL Server as usual (the tool supports SQL Server 2000 and 2008 style connections). 2. Do not pick the database with the drop down button: type the database name (for e...

    ✓ Confirmed by the topic starterRaGEZONE · 2014-02-11
  2. Server setupOpenMUany

    OpenMU docker compose: the database container exits with a PostgreSQL 18 PGDATA notice and openmu crashes too.

    1. Postgres 18 images moved PGDATA to a version specific folder, so the old mount at /var/lib/postgresql/data no longer fits. 2. Pull the current OpenMU deploy files (PR #666, November 20...

    ✓ Confirmed in the issueGitHub (MUnique/OpenMU) · 2025-11-21
  3. Server setupOpenMUany

    OpenMU starts with -demo but -reinit fails: Postgres says column ExcellentItemDropLevelDelta of GameConfiguration does not exist.

    1. Two recent EF migrations were not picked up during a Postgres reinit, so the table was created without the new column. 2. Update your OpenMU checkout or image to a build that contains...

    ✓ Confirmed in the issueGitHub (MUnique/OpenMU) · 2026-04-11
  4. Server setupclassic

    After restoring an old backup, characters with the same name can be created on different accounts.

    1. The name primary key was lost. 2. Delete the duplicated rows one by one. 3. Restore the primary key before allowing new characters.

    ✓ Confirmed by the topic starterImperyus Games Brasil · 2010-12-17
  5. Server setup

    JoinServer and DataServer cannot connect to the database although the backup is restored

    These files had the database name MuOnlineS6 in the server configs while the database was restored as MuOnline, so the servers looked for a database that does not exist. 1. In SQL Server...

    ✓ Confirmed by the topic starterTUServerMU · 2018-09-27
  6. Server setupOpenMUany

    OpenMU: after a restart all my configuration and data were gone and the database was initialized again.

    1. With Docker the Postgres data must live in a volume. 2. The provided docker-compose files persist it in volumes, so the data was lost because the volumes were deleted or the setup did...

    ✓ Confirmed in the issueGitHub (MUnique/OpenMU) · 2023-11-11
  7. Server setupOpenMUany

    OpenMU Docker server goes to 100% CPU after about two weeks (a kdevtmpfsi style crypto miner).

    1. The maintainer found the way in: the Postgres port was exposed to the internet in the Traefik deployment (fixed in PR #435, July 2024). 2. Use the current deploy files, never publish p...

    ✓ Confirmed in the issueGitHub (MUnique/OpenMU) · 2024-07-17
  8. Server setupany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Confirmed by the topic starterTUServerMU · 2020-07-23
Still stuck? Ask the MU Assistant Search MuGPS Search MUTube

MuADMINS Community Alpha: free and community made, in active development.