S

Supabase•6mo ago•

2 replies

SUBID DAS

FATAL: 28P01: password authentication failed for user "postgres"

im using supabase cli locally, but i want to change the database password, and i changed but now the supabase studio is not working as its using the old password, how can i update the password in supabase studio ?
for context i used supabase cli to create the supabase project with "supabase start"
and changed password with this command:
alter user anon with password '${new_passwd}';
alter user authenticated with password '${new_passwd}';
alter user authenticator with password '${new_passwd}';
alter user dashboard_user with password '${new_passwd}';
alter user pgbouncer with password '${new_passwd}';
alter user postgres with password '${new_passwd}';
alter user service_role with password '${new_passwd}';
alter user supabase_admin with password '${new_passwd}';
alter user supabase_auth_admin with password '${new_passwd}';
alter user supabase_functions_admin with password '${new_passwd}';
alter user supabase_read_only_user with password '${new_passwd}';
alter user supabase_replication_admin with password '${new_passwd}';
alter user supabase_storage_admin with password '${new_passwd}';

drop schema _supavisor CASCADE;
create schema if not exists _supavisor;
alter schema _supavisor owner to supabase_admin;

DO $$
BEGIN
IF EXISTS (
SELECT 1
FROM information_schema.tables
WHERE table_schema = '_analytics'
AND table_name = 'source_backends'
) THEN
UPDATE _analytics.source_backends
SET config = jsonb_set(
config,
'{url}',
'"postgresql://supabase_admin:${new_passwd}@db:5432/postgres"',
false
)
WHERE type = 'postgres';
END IF;
END
$$;