PostgreSQL container fails with "99-roles.sql: No such file or directory" error causing restart loop

[arend-vanderveen]

Bug Description

The Supabase local database container fails to start properly due to a missing 99-roles.sql file, causing a restart loop that prevents database initialization and migration application.

Steps to Reproduce

1. Install Supabase CLI v2.67.1
2. Run supabase start
3. Container enters restart loop with error: psql: error: /docker-entrypoint-initdb.d/init-scripts/99-roles.sql: No such file or directory

Expected Behavior

Database should initialize successfully without errors.

Actual Behavior

Container restarts repeatedly, preventing database from completing initialization.

Environment

• Supabase CLI Version: 2.67.1
• OS: macOS 24.6.0 (Darwin ARM64)
• Docker Version: 28.5.1
• Project ID: zndanyasplhiqeyawqmz

Error Logs

psql: error: /docker-entrypoint-initdb.d/init-scripts/99-roles.sql: No such file or directory

Additional Context

• Created placeholder file at supabase/init/init-scripts/99-roles.sql but it's not being copied to container
• Issue persists across CLI versions (tested 2.65.5 and 2.67.1)
• Prevents local database reset and migration application

[7ttp]

hi @arend-vanderveen thanks for reporting 💚

99-roles.sql isn't a part of the cli,
i believe this is a stale docker volume from a previous setup.
try removing all supabase docker volumes and running supabase start fresh.

[arend-vanderveen]

This issue has been resolved. I had to: 1. Delete docker volume, images and containers 2. Delete supabase/.temp I was then able to execute the following: supabase start supabase db reset Thanks for the suggestion, Arend

…

On Tue, Dec 16, 2025 at 2:00 PM Vaibhav ***@***.***> wrote: *7ttp* left a comment (supabase/cli#4631) <#4631 (comment)> hi @arend-vanderveen <https://github.com/arend-vanderveen> thanks for reporting 💚 99-roles.sql isn't a part of the cli, i believe this is a stale docker volume from a previous setup. try removing all supabase docker volumes and running supabase start fresh. — Reply to this email directly, view it on GitHub <#4631 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BYGW5FCYDGGEGIEUF4ORC5T4CBJFHAVCNFSM6AAAAACPHCBBKWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTMNRRHE3DCOJWHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[arend-vanderveen]

I am back to having the same issue. I have tried changing from postgres 16 to postgres 15 in config.toml but that did not help.