Skip to content

Cannot pull/start supabase locally for existing project #3553

New issue
New issue
Open
Open
Cannot pull/start supabase locally for existing project#3553
@DonIsaac

Description

@DonIsaac
DonIsaac
opened on May 10, 2025

Describe the bug
Supabase Docker container fails to start when running supabase db pull or supabase start.

Full log with --debug 
Using connection pooler: postgresql://postgres.[REDACTED]:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.supabase.com:6543/postgres
Supabase CLI 2.22.12
Connecting to remote database...
2025/05/10 14:07:59 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres.iligpfkvyargzgpcrquc"}}
2025/05/10 14:07:59 PG Recv: {"Type":"AuthenticationSASL","AuthMechanisms":["SCRAM-SHA-256"]}
2025/05/10 14:07:59 PG Send: {"Type":"SASLInitialResponse","AuthMechanism":"SCRAM-SHA-256","Data":"n,,n=,r=HxpOckBHAHMWdi4HPXs8Zf7x"}
2025/05/10 14:07:59 PG Recv: {"Type":"AuthenticationSASLContinue","Data":"r=HxpOck[REDACTED],i=4096"}
2025/05/10 14:07:59 PG Send: {"Type":"SASLResponse","Data":"c=biws,r=HxpOck[REDACTED]"}
2025/05/10 14:07:59 PG Recv: {"Type":"AuthenticationSASLFinal","Data":"v=[REDACTED]="}
2025/05/10 14:07:59 PG Recv: {"Type":"AuthenticationOK"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"DateStyle","Value":"ISO, MDY"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"IntervalStyle","Value":"postgres"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"TimeZone","Value":"UTC"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"application_name","Value":"Supavisor"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"client_encoding","Value":"UTF8"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"default_transaction_read_only","Value":"off"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"in_hot_standby","Value":"off"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"integer_datetimes","Value":"on"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"is_superuser","Value":"off"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"server_encoding","Value":"UTF8"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"server_version","Value":"15.8"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"session_authorization","Value":"postgres"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterStatus","Name":"standard_conforming_strings","Value":"on"}
2025/05/10 14:08:00 PG Recv: {"Type":"BackendKeyData","ProcessID":1277947470,"SecretKey":3168493970}
2025/05/10 14:08:00 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2025/05/10 14:08:00 PG Send: {"Type":"Parse","Name":"lrupsc_1_0","Query":"SELECT version FROM supabase_migrations.schema_migrations ORDER BY version","ParameterOIDs":null}
2025/05/10 14:08:00 PG Send: {"Type":"Describe","ObjectType":"S","Name":"lrupsc_1_0"}
2025/05/10 14:08:00 PG Send: {"Type":"Sync"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParseComplete"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterDescription","ParameterOIDs":[]}
2025/05/10 14:08:00 PG Recv: {"Type":"RowDescription","Fields":[{"Name":"version","TableOID":29294,"TableAttributeNumber":1,"DataTypeOID":25,"DataTypeSize":-1,"TypeModifier":-1,"Format":0}]}
2025/05/10 14:08:00 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2025/05/10 14:08:00 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"lrupsc_1_0","ParameterFormatCodes":null,"Parameters":[],"ResultFormatCodes":[0]}
2025/05/10 14:08:00 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2025/05/10 14:08:00 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2025/05/10 14:08:00 PG Send: {"Type":"Sync"}
2025/05/10 14:08:00 PG Recv: {"Type":"BindComplete"}
2025/05/10 14:08:00 PG Recv: {"Type":"RowDescription","Fields":[{"Name":"version","TableOID":29294,"TableAttributeNumber":1,"DataTypeOID":25,"DataTypeSize":-1,"TypeModifier":-1,"Format":0}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250107065411"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250107070244"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250108142344"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250118080746"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250118082403"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250118155326"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250119153524"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250119155415"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250119161913"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250119162240"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250129084732"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250201165015"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250212163018"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250212163229"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250225105307"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250304121839"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250304124021"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250304131757"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250304134107"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250304144935"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311122338"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311122400"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311122448"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311130433"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311130628"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250311135116"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250312035612"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250312041749"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250312043727"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250315143339"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250323173940"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250323175050"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250327043147"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250407130323"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408023815"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408043025"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408043725"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408083231"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408110657"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250408142117"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250424115151"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250507035823"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"20250510040105"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"CommandComplete","CommandTag":"SELECT 43"}
2025/05/10 14:08:00 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2025/05/10 14:08:00 PG Send: {"Type":"Parse","Name":"lrupsc_1_1","Query":"-- List user defined schemas, excluding\n--  Extension created schemas\n--  Supabase managed schemas\nselect pn.nspname\nfrom pg_namespace pn\nleft join pg_depend pd\n  on pd.objid = pn.oid\njoin pg_roles r \n  on pn.nspowner = r.oid\nwhere pd.deptype is null\n  and not pn.nspname like any($1)\n  and r.rolname != 'supabase_admin'\norder by pn.nspname\n","ParameterOIDs":null}
2025/05/10 14:08:00 PG Send: {"Type":"Describe","ObjectType":"S","Name":"lrupsc_1_1"}
2025/05/10 14:08:00 PG Send: {"Type":"Sync"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParseComplete"}
2025/05/10 14:08:00 PG Recv: {"Type":"ParameterDescription","ParameterOIDs":[1009]}
2025/05/10 14:08:00 PG Recv: {"Type":"RowDescription","Fields":[{"Name":"nspname","TableOID":2615,"TableAttributeNumber":2,"DataTypeOID":19,"DataTypeSize":64,"TypeModifier":-1,"Format":0}]}
2025/05/10 14:08:00 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2025/05/10 14:08:00 PG Send: {"Type":"Bind","DestinationPortal":"","PreparedStatement":"lrupsc_1_1","ParameterFormatCodes":[1],"Parameters":[{"binary":"0000000100000000000000190000000b0000000100000013696e666f726d6174696f6e5c5f736368656d610000000570675c5f250000000b5c5f616e616c79746963730000000a5c5f7265616c74696d650000000b5c5f737570617669736f72000000097067626f756e6365720000000470676d71000000087067736f6469756d000000057067746c650000001473757061626173655c5f6d6967726174696f6e73000000057661756c74"}],"ResultFormatCodes":[1]}
2025/05/10 14:08:00 PG Send: {"Type":"Describe","ObjectType":"P","Name":""}
2025/05/10 14:08:00 PG Send: {"Type":"Execute","Portal":"","MaxRows":0}
2025/05/10 14:08:00 PG Send: {"Type":"Sync"}
2025/05/10 14:08:00 PG Recv: {"Type":"BindComplete"}
2025/05/10 14:08:00 PG Recv: {"Type":"RowDescription","Fields":[{"Name":"nspname","TableOID":2615,"TableAttributeNumber":2,"DataTypeOID":19,"DataTypeSize":64,"TypeModifier":-1,"Format":1}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"drizzle"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"extensions"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"DataRow","Values":[{"text":"public"}]}
2025/05/10 14:08:00 PG Recv: {"Type":"CommandComplete","CommandTag":"SELECT 3"}
2025/05/10 14:08:00 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
2025/05/10 14:08:10 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres"}}
2025/05/10 14:08:10 PG Recv: {"Type":"AuthenticationSASL","AuthMechanisms":["SCRAM-SHA-256"]}
2025/05/10 14:08:10 PG Send: {"Type":"SASLInitialResponse","AuthMechanism":"SCRAM-SHA-256","Data":"n,,n=,r=K5ERfN4Vx6OWalRO5WFfZDtT"}
2025/05/10 14:08:10 PG Recv: {"Type":"AuthenticationSASLContinue","Data":"r=K5ERfN4Vx6OWalRO5WFfZDtTj+AGCbgIKiMLHWPavTNDuqEL,s=aYLr72lChDhFK8h9bsTgyQ==,i=4096"}
2025/05/10 14:08:10 PG Send: {"Type":"SASLResponse","Data":"c=biws,r=K5ERfN4Vx6OWalRO5WFfZDtTj+AGCbgIKiMLHWPavTNDuqEL,p=p1z8cWRxOqUe0BxAOTuIvDc6GtQdgPWiCU4Un85u1Do="}
2025/05/10 14:08:10 PG Recv: {"Type":"AuthenticationSASLFinal","Data":"v=sfwlvc3SXt485WZz58UWJ6N2yxIDOmpYGzl4j5gVkN0="}
2025/05/10 14:08:10 PG Recv: {"Type":"AuthenticationOK"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"application_name","Value":""}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"client_encoding","Value":"UTF8"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"DateStyle","Value":"ISO, MDY"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"default_transaction_read_only","Value":"off"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"in_hot_standby","Value":"off"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"integer_datetimes","Value":"on"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"IntervalStyle","Value":"postgres"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"is_superuser","Value":"off"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"server_encoding","Value":"UTF8"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"server_version","Value":"15.8"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"session_authorization","Value":"postgres"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"standard_conforming_strings","Value":"on"}
2025/05/10 14:08:10 PG Recv: {"Type":"ParameterStatus","Name":"TimeZone","Value":"UTC"}
2025/05/10 14:08:10 PG Recv: {"Type":"BackendKeyData","ProcessID":192,"SecretKey":362266152}
2025/05/10 14:08:10 PG Recv: {"Type":"ReadyForQuery","TxStatus":"I"}
Initialising schema...
+ ulimit -nshadow database...
+ '[' '!' -z '' ']'
+ export ERL_CRASH_DUMP=/tmp/erl_crash.dump
+ ERL_CRASH_DUMP=/tmp/erl_crash.dump
+ '[' false = true ']'
+ echo 'Running migrations'
+ sudo -E -u nobody /app/bin/migrate
+ '[' true = true ']'abase...
+ echo 'Seeding selfhosted Realtime'
+ sudo -E -u nobody /app/bin/realtime eval 'Realtime.Release.seeds(Realtime.Repo)'
+ echo 'Starting Realtime'...
+ ulimit -n
+ exec /app/bin/realtime eval '{:ok, _} = Application.ensure_all_started(:realtime)
{:ok, _} = Realtime.Tenants.health_check("realtime-dev")'
[os_mon] memory supervisor port (memsup): Erlang has closed
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
2025/05/10 14:08:13 PG Send: {"Type":"Terminate"}
2025/05/10 14:08:13 PG Send: {"Type":"Terminate"}
failed to start docker container: Error response from daemon: unable to find user supabase: no matching entries in passwd file

To Reproduce

  • Have an existing project linked
  • run supabase db pull

Expected behavior
Command should run successfully

System information
Rerun the failing command with --create-ticket flag.

  • Ticket ID: 956afb4fdffe46e99823c33c0262b026
  • Version of OS: Darwin 24.4.0 arm64 arm
  • Version of CLI: 2.22.12
  • Version of Docker: Docker version 27.3.1, build ce12230
  • Versions of services: [output from supabase services command]
   SERVICE IMAGE          | LOCAL                  | LINKED     
  ------------------------|------------------------|------------
   supabase/postgres      | 15.8.1.044             | 15.8.1.044 
   supabase/gotrue        | v2.170.0               | v2.170.0   
   postgrest/postgrest    | v12.2.3                | v12.2.3    
   supabase/realtime      | v2.34.47               | -          
   supabase/storage-api   | v1.22.11               | -          
   supabase/edge-runtime  | v1.67.4                | -          
   supabase/studio        | 2025.05.05-sha-3c3fe9b | -          
   supabase/postgres-meta | v0.88.9                | -          
   supabase/logflare      | 1.12.0                 | -          
   supabase/supavisor     | 2.5.1                  | -

Additional context

  • Version of Node.js: v20.12.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions