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?
MarkAssPandi
@MarkAssPandi@shrimpnet.gej.pet
Experimental instance (or not, ig its staying i dont care anymore)
A queer moron that does cool shit sometimes like being a speaker at an event
Certified euro cuck
A woman
Idk
Nerd
Website: kamila.pet
If something I say sounds insane it's usually a shitpost, but if you wanna be sure u can ask (It will give me feedback to add notation so that I can be sure it's not misunderstood)
I can be weird and lewd here, I usually try to CW stuff correctly, mostly succeed but viewer discretion is advised, I am not strictly mDNI but I def would require not interacting with lewd posts, and I will block if I realize that this is happening.
Also lewd stuff I post are usually jokes, I am in a monogamous relationship so do NOT try to unironically hit on me. Ironically is fine if I know you and its all for jokes.
Few statements that I believe so if u dont believe you might not like me and I might not like you:
- Trans rights (I mean ALL trans rights. Transfem, masc, enby, anything else too, you are all valid)
- Gay rights
- Queer rights
- MAPs aren't queers. Pedophilia is not a sexuality.
- Privacy matters
See also: @markasspandi
A queer moron that does cool shit sometimes like being a speaker at an event
Certified euro cuck
A woman
Idk
Nerd
Website: kamila.pet
If something I say sounds insane it's usually a shitpost, but if you wanna be sure u can ask (It will give me feedback to add notation so that I can be sure it's not misunderstood)
I can be weird and lewd here, I usually try to CW stuff correctly, mostly succeed but viewer discretion is advised, I am not strictly mDNI but I def would require not interacting with lewd posts, and I will block if I realize that this is happening.
Also lewd stuff I post are usually jokes, I am in a monogamous relationship so do NOT try to unironically hit on me. Ironically is fine if I know you and its all for jokes.
Few statements that I believe so if u dont believe you might not like me and I might not like you:
- Trans rights (I mean ALL trans rights. Transfem, masc, enby, anything else too, you are all valid)
- Gay rights
- Queer rights
- MAPs aren't queers. Pedophilia is not a sexuality.
- Privacy matters
See also: @markasspandi