Selfhosted

59950 readers

274 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam.
Posts here are to be centered around self-hosting. Please ensure it is clear in your post how it relates to self-hosting.
Don't duplicate the full text of your blog or git here. Just post the link for folks to click.
Submission headline should match the article title.
No trolling.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

201

If I self host a Lemmy instance for just myself and maybe a few friends are there any risks? (lemmy.world)

submitted 3 years ago by VitaminH@lemmy.world to c/selfhosted@lemmy.world

63 comments fedilink hide all child comments

Looking to maybe self host my own instance, I'm still learning about the fediverse. If a different instance that I federate with hosts something illegal are there risks to me? Is anything from other instances hosted on my server like a copy of it? Or would I only end up hosting things my users post? I'm paranoid and sorry if this is a silly question.

you are viewing a single comment's thread
view the rest of the comments

[–] gabe565@lemmy.cook.gg 2 points 3 years ago (1 children)

Definitely! I'm hosting in Kubernetes so I won't post the full thing, but here's the actual command that I run hourly. Make sure to replace the values for database, username, and password.

PGPASSWORD=password psql --dbname=database --username=username --command="DELETE FROM activity WHERE published < NOW() - INTERVAL '3 days';"

[–] ipkpjersi@lemmy.one 1 points 3 years ago (1 children)

Awesome, that was just as straightforward as I was hoping it was, thanks! I am more familiar with MySQL as I haven't used Postgres a ton but SQL is SQL after all lol

[–] gabe565@lemmy.cook.gg 2 points 3 years ago

You're welcome! Makes sense. They're somehow so similar yet so different lol