Stephan Hahn <stephan-hahn(at)gmx(dot)net> writes:
> Does it cause any problems if i set the user postgres to readonly?
Not really sure what you have in mind there, but superusers bypass
all permissions checks. Even if it worked, it'd be likely to break
the autovacuum daemon.
regards, tom lane