Modifying the database inside of a backup to remove a duplicate key tag so that it doesn't fail when restoring

[merefield (Robert)]

@Drew-ART

My Discourse update failed due to a duplicate key, one of my tags is doubled up. To fix the update issue i needed to do a fresh Discourse install

Why?

Why could you not fix this ‘online’ by restarting the app, entering the container, entering postgres and then dealing with the data entry immediately?

Failed upgrade: UniqueViolation: duplicate key value violates unique constraint "data_explorer_queries_pkey"

So restart the container? ./launcher start app Then you want something like: ./launcher enter app then: su postgres -c 'psql discourse'