Docker: Snapshot restoration is still broken

[sgillespie]

OS Your OS: Docker

Versions The db-sync version (eg cardano-db-sync --version): PostgreSQL version: Any

Build/Install Method The method you use to build or install cardano-db-sync: docker

Run method The method you used to run cardano-db-sync (eg Nix/Docker/systemd/none): docker

Problem Report Even after recent docker/nix fixes, the snapshot restoration script is still failing:

$ docker compose logs -f cardano-db-sync                                                                                 
WARN[0000] The "DISABLE_LEDGER" variable is not set. Defaulting to a blank string. 
WARN[0000] /home/sgillespie/dev/iohk/cardano-db-sync/docker-compose.yml: `version` is obsolete                          
cardano-db-sync-1  | /run/secrets   
cardano-db-sync-1  | Generating PGPASS file           
cardano-db-sync-1  | Connecting to network: mainnet                                                                                   
cardano-db-sync-1  | db/                              
cardano-db-sync-1  | db/4128.dat.gz
cardano-db-sync-1  | db/4125.dat.gz
<-- Snip -->
cardano-db-sync-1  | db/4095.dat.gz
cardano-db-sync-1  | 123292792-ef4ff28a2e-482.lstate.gz
cardano-db-sync-1  | ERROR:  cannot drop objects owned by role postgres because they are required by the database system
cardano-db-sync-1 exited with code 0