We have a fly pg app that is stuck in read only mode - we have tried everything possible.
default_transaction_read_only will always be ON even after:
ALTER SYSTEM SET default_transaction_read_only = OFF;
ALTER DATABASE database_name SET default_transaction_read_only = OFF;
I have a feeling the app hit 90% usage on the volumes which have now been expanded.
We even tried forking to a whole new DB but we are still stuck, can someone please help?? Very frustrating experience.