User avatar
MarkAssPandi
@MarkAssPandi@shrimpnet.gej.pet
anyone working on iceshrimp can I ask something (boost appreciated so someone can see)

what postgres permisions does user (as in postgres group or whatever those are called) need for iceshrimp to work
I recently tried to setup iceshrimp with external postgres and I made separate iceshrimp user for it, gave it permission to create tables and gave full permission for iceshrimp database
but it was still erroring when I was migrating the database, from what I remember it complained about not being able to make tables under "public"
since it was a small postgres setup, at that time not used by any other service, I just gave iceshrimp an superuser permissions, and it worked fine, but I wanted to make new setup for multiple services and I'd like to have some more granular control over what permissions a given user has, so the question is: what permissions should iceshrimp user have?