Restored Supabase Project Lacks Postgres Superuser Privileges, Breaking FDW Creation

Supabase's restore process fails to preserve or re-apply the SUPERUSER attribute on the postgres role, leaving the restored project with restricted privileges that block creation of foreign data wrappers and other superuser-only operations.

1. Un-pause or restore a Supabase project. 2. Open the SQL Editor. 3. Execute `CREATE FOREIGN DATA WRAPPER clickhouse_wrapper ...` or attempt to use the ClickHouse Wrapper UI. 4. Observe error: `42501: permission denied to create foreign-data wrapper "clickhouse_wrapper" HINT: Must be superuser to create a foreign-data wrapper.`

Granting SUPERUSER to the postgres role elevates privileges to the maximum level, increasing the risk of accidental data loss, unauthorized access, or destructive operations. If this role is used by application connections, ensure it is trusted. To roll back, execute `ALTER ROLE postgres NOSUPERUSER;`. Long-term fix should address the restore process to correctly preserve role attributes.