Setting temp_file_limit
As a security precaution i would like to be able to set temp_file_limit in a session. However i get a permissions denied error, im assuming because neon does not give out superuser roles to us (which is understandable). Is there any possible workarounds here? Open to using other non-superuser settings that achieve a similar effect (for context im trying to block malicious queries that would consume a ton of resources, such as a recursive cte that runs forever).
Thanks !
more info:
reproduce this by simply connecting to a neondb as neon_owner and doing
set temp_file_limit='1MB';0 Replies