DevOps dude, self-hoster, space nerd.

  • 0 Posts
  • 11 Comments
Joined 1 year ago
cake
Cake day: June 12th, 2023

help-circle
  • I’ve got a 1972 VW Super Beetle that I’ll never get rid of. It’s not really a desirable version or year of the Beetle, but my dad, grandpa, and I restored it when I was 9. My grandpa died in 2020 and he worked on cars his whole life. It’s cool to have a physical thing that he made possible using a lifetime of skills. Plus, my kid is getting old enough to work on it with me, and I think it’s awesome to have 4 generations of my family wrenching on it.




  • rs5th@lemmy.scottlabs.iotoChat@beehaw.orgTest Post
    link
    fedilink
    English
    arrow-up
    8
    ·
    1 year ago

    If anyone else has made it this far and are thinking “ah balls, I’m using ingress-nginx”, here’s the ingress annotation for you!

    nginx.ingress.kubernetes.io/configuration-snippet: |
                if ($http_accept = "application/activity+json") {
                  set $proxy_upstream_name "lemmy-lemmy-8536";
                }
                if ($http_accept = "application/ld+json; profile=\"https://www.w3.org/ns/activitystreams\"") {
                  set $proxy_upstream_name "lemmy-lemmy-8536";
                }
                if ($request_method = POST) {
                  set $proxy_upstream_name "lemmy-lemmy-8536";
                }
    
    

  • rs5th@lemmy.scottlabs.iotoChat@beehaw.orgTest Post
    link
    fedilink
    English
    arrow-up
    11
    ·
    1 year ago

    Here’s a cronjob to clean up the useless activity table every day:

    
    apiVersion: batch/v1beta1
    kind: CronJob
    metadata:
      name: postgresql-cleanup
      namespace: lemmy
    spec:
      schedule: "0 0 * * *"
      jobTemplate:
        spec:
          template:
            spec:
              containers:
              - name: postgres-cleanup
                image: postgres:alpine
                command: ["psql", "--host=postgresql", "--dbname=postgres", "--username=postgres", "--command=DELETE FROM activity WHERE published < NOW() - INTERVAL '1 day';"]
                env:
                - name: PGPASSWORD
                  valueFrom:
                    secretKeyRef:
                      name: postgresql
                      key: postgres-password
              backoffLimit: 0
              ttlSecondsAfterFinished: 3600