Re: Read-only connection mode for AI workflows.

On 7/8/25 18:46, Mat Arye wrote:
> It would be nice to force a connection into read-only mode. Connection
> setup is usually not AI controlled while the SQL executed sometimes is.
> That's why being able to control read-only mode on the connection level
> would be useful.
>
> I'd be happy to submit a patch if there is interest in this feature
> (especially if I get some pointers to where people would like to see
> this implemented).

I believe the pg_readonly [1] extension does what you're looking for, so
you might want to give it a try.

Could you share a bit more about your situation? For example, are you
thinking of making specific users read-only, or do you want all database
connections to be read-only? Also, which commands do you want to
restrict? For instance, vacuum isn't a DML command, but it can still
change the state of table pages and pg_catalog.

[1] https://github.com/pierreforstmann/pg_readonly

--
regards, Andrei Lepikhov,
pgEdge