supabase cdc is broken

[pkit]

Describe the bug

Supabase CDC is currently unusable

• IPV6 resolver is not supported
• IPV4 connection fails because of a sloppy permission check

Error message/log

INVALID_ARGUMENT: Postgres user must have select privilege on table 'public.test1' (SQLSTATE XX000)

To Reproduce

IPV6 connection

CREATE SOURCE IF NOT EXISTS supabase_test WITH (
   connector='postgres-cdc',
   hostname='db.blablabla.supabase.co',
   port='5432',
   username='postgres',
   password='*********',
   database.name='postgres',
   slot.name='test_slot',
   publication.name='test_pub'
);

Fails with:

Internal error: The connection attempt failed. (SQLSTATE XX000)

because IPV6-only DNS resolve is needed.

IPV4 connection

CREATE SOURCE IF NOT EXISTS supabase_test WITH (
   connector='postgres-cdc',
   hostname='aws-0-us-east-2.pooler.supabase.com',
   port='5432',
   username='postgres.blablaba',
   password='********',
   database.name='postgres',
   slot.name='test_slot',
   publication.name='test_pub'
);

Fails with:

INVALID_ARGUMENT: Postgres user must have select privilege on table 'public.test1' (SQLSTATE XX000)

because it uses the username from the connector instead of current_user

Expected behavior

Should work

How did you deploy RisingWave?

it's a cloud version

The version of RisingWave

cloud

Additional context

No response