Looking for help getting my local project up to th...
# help-and-questions
z
Good morning. I am looking for some help getting my local project up to speed. I am nearing v1, and that means no more hail mary database changes in the web console.I had decided to ignore the cli for everything but edge functions, now I am paying for it.
supabase remote commit --debug
gives me error
Copy code
...
2023/05/25 09:05:57 PG Send: {"Type":"StartupMessage","ProtocolVersion":196608,"Parameters":{"database":"postgres","user":"postgres"}}
2023/05/25 09:05:57 PG Recv: {"Type":"AuthenticationSASL","AuthMechanisms":["SCRAM-SHA-256"]}
2023/05/25 09:05:57 PG Send: {"Type":"SASLInitialResponse","AuthMechanism":"SCRAM-SHA-256","Data":"n,,n=,r=du1hqGfLEFgx4XrpnRKsj+9Z"}
2023/05/25 09:05:57 PG Recv: {"Type":"AuthenticationSASLContinue","Data":"r=du1hqGfLEFgx4XrpnRKsj+9ZkUQNMBV3doWl3ycFRUbqtkJ9,s=vxLvuGMsKfKIEl1JRBbsiQ==,i=4096"}
2023/05/25 09:05:57 PG Send: {"Type":"SASLResponse","Data":"c=biws,r=du1hqGfLEFgx4XrpnRKsj+9ZkUQNMBV3doWl3ycFRUbqtkJ9,p=LnAY4FOG73/n5u+lFzU222OCWSmkUn7R1elrIxSYpSk="}
2023/05/25 09:05:58 PG Recv: {"Type":"AuthenticationSASLFinal","Data":"v=vXxebxj0pYh0v/8EySC0zCUEp1XREkpDXHaILk4YfsI="}
2023/05/25 09:05:58 PG Recv: {"Type":"AuthenticationOK"}
2023/05/25 09:05:58 PG Recv: {"Type":"ParameterStatus","Name":"default_transaction_read_only","Value":"off"}
.
i can't use
supabase db push
because the remote is the important one
I've been using edge functions, but I have paid zero attention to migrations, and it seems a rabbit hole.
my
migrations
folder is empty
Error: The remote database's migration history is not in sync with the contents of supabase/migrations. Resolve this by:
Is it best to just delete the local and reinitialize a local supabase repo?