I know that I can disable all remote connections to a Postgresql database by setting the listen_addresses to 'localhost'.
My question is: Can I disable remote access for specific users? I want to disable remote access for all superusers to reduce the attack surface of my database.