log_min_messages requires elevated privileges

[nkreiger]

Chore

Describe the chore

In order to set the parameter log_min_messages you need elevated privileges,

realtime/lib/extensions/postgres_cdc_rls/repo/migrations/20230328144023_create_list_changes_function.ex

Line 11 in e34899b

set log_min_messages to 'fatal'

These privileges cannot be achieved in certain managed Cloud SQL instances. It would be great to wrap this in a function, or maybe check the permissions before running it?

Additional context

Maybe something like this, or something smarter

DO $$
BEGIN
BEGIN
-- Attempt to set the parameter
EXECUTE 'SET log_min_messages TO ''fatal''';
RAISE NOTICE 'log_min_messages set to ''fatal''';
EXCEPTION
WHEN others THEN
-- Handle the error when privileges are insufficient
RAISE NOTICE 'You do not have the required privileges to set log_min_messages';
END;
END $$

[nkreiger]

Any thoughts about this? I can line up a PR if there is no objection?

#617

for review