GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE

  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Notices by Vivi Nella Verita (verita84eva@poster.place), page 3

  1. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 27-Apr-2024 06:05:19 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • Pleroma-tan
    • Tyler
    @tyler @kirby

    Is it right to groom kids with Linux? :trannycide2:
    In conversation Saturday, 27-Apr-2024 06:05:19 JST from poster.place permalink
  2. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 27-Apr-2024 01:59:16 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • DJ :debian: :coolcat: :colombia:
    @dj


    https://pastebin.com/AHQeTtCp
    In conversation Saturday, 27-Apr-2024 01:59:16 JST from poster.place permalink

    Attachments

    1. Domain not in remote thumbnail source whitelist: pastebin.com
      clean-akkoma() { DATABASES=(akkoma detroitriotcity) echo "Stopping A - Pastebin.com
      Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
  3. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Saturday, 27-Apr-2024 01:59:09 JST Vivi Nella Verita Vivi Nella Verita
    • DJ :debian: :coolcat: :colombia:
    @dj

    A function to actually clean Akkoma /Pleroma well

    ```
    DATABASES=(akkoma detroitriotcity)
    echo "Stopping Akkoma"
    systemctl stop akkoma
    for i in "${DATABASES[@]}"; do
    echo "Scanning Fderated Posts to Delete: $i"
    su postgres -s /bin/bash -lc "echo \"SELECT COUNT(*) FROM \"objects\" AS o0 WHERE (o0.\"data\"->'to' ? 'https://www.w3.org/ns/activitystreams#Public' OR o0.\"data\"->'cc' ? 'https://www.w3.org/ns/activitystreams#Public') AND (o0.\"inserted_at\" < now() - interval '15 days' ) AND (split_part(o0.\"data\"->>'actor', '/', 3) != '$i')\" | psql $i"
    echo "Deleting Objects for: $i"
    su postgres -s /bin/bash -lc "echo \"DELETE FROM \"objects\" AS o0 WHERE (o0.\"data\"->'to' ? 'https://www.w3.org/ns/activitystreams#Public' OR o0.\"data\"->'cc' ? 'https://www.w3.org/ns/activitystreams#Public') AND (o0.\"inserted_at\" < now() - interval '15 days' ) AND (split_part(o0.\"data\"->>'actor', '/', 3) != '$i')\" | psql $i"
    echo "Deleting Activities for: $i"
    su postgres -s /bin/bash -lc "echo \"DELETE FROM \"activities\" where data->>'type' = 'Create' and local = 'f' and inserted_at < now() - interval '10 days'"\" | psql $i
    echo "Starting Akkoma: $i"
    systemctl start akkoma
    done
    }
    ```
    In conversation Saturday, 27-Apr-2024 01:59:09 JST from poster.place permalink

    Attachments


  4. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 15:01:41 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • 313Chris:hellokitty_headbang:
    • Christi Junior
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i @admin @ChristiJunior

    Some success. After Repack, Activities table went from 38GB to 15GB. I deleted Federated Activites up to the last 10 days. WTF happened in the last 10 days on Fedi lol

    Total Disk Footprint of the Database Dir is now 34GB. It was 93GB before we started the work today.

    Thanks everyone!
    In conversation Friday, 26-Apr-2024 15:01:41 JST from poster.place permalink
  5. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:47:20 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i

    pg_backup will not include all the deleted data right?
    In conversation Friday, 26-Apr-2024 09:47:20 JST from poster.place permalink
  6. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:46:05 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i

    will do repack now. Doing a dump first with pg_backup to see if size is smaller
    In conversation Friday, 26-Apr-2024 09:46:05 JST from poster.place permalink
  7. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 09:45:08 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i

    I ran it , even ran it again to 30 days. Activities size didn't change. Heavy DIsk IO when running so it was doing something
    In conversation Friday, 26-Apr-2024 09:45:08 JST from poster.place permalink

    Attachments


    1. https://poster.place/media/ec26248c631c9c80eb53217e94ab5430a1f644dcc440c83741cd42f681c57a4c.png
  8. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:33:30 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i oh boy. Try deleting shit from your own instance and oban_jobs filles up and kills your disk io . That was a first big issue with DRc when trying to clean it up
    In conversation Friday, 26-Apr-2024 06:33:30 JST from poster.place permalink
  9. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:25:41 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i

    Ah is that why deletes are always slow and takes days like with the original commands you gave me ?
    In conversation Friday, 26-Apr-2024 06:25:41 JST from poster.place permalink
  10. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:24:39 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • 
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @mint @colonelj @i

    We did follow a lot. I just recently turned it off . Database grew form 60gb to 93gb in a ween
    In conversation Friday, 26-Apr-2024 06:24:39 JST from poster.place permalink
  11. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:13:16 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    Running:

    ```
    detroitriotcity=# delete from activities where data->>'type' = 'Create' and local = 'f' and inserted_at < now() - interval '365 days';
    ```

    Now
    In conversation Friday, 26-Apr-2024 06:13:16 JST from poster.place permalink
  12. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:11:11 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    lol yeah I been doing that daily since you told me via cron. I have no idea how to do the Activities table safely. Your suggestion for said tables does not really do much. It's yuge!
    In conversation Friday, 26-Apr-2024 06:11:11 JST from poster.place permalink
  13. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 06:11:08 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    Ty. DRC almost 90 GB and is growing fast. Local posts would not be deleted? Only Federated?
    In conversation Friday, 26-Apr-2024 06:11:08 JST from poster.place permalink
  14. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 05:33:40 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    Ah, there still is not a good way to even maintain the Pleroma/Akkoma database. It took me two days to delete 157354 old posts using it's built-in commands and they just let the Activities table grow and grow without a way to clean it
    In conversation Friday, 26-Apr-2024 05:33:40 JST from poster.place permalink
  15. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 05:33:04 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    I can't read all of that
    In conversation Friday, 26-Apr-2024 05:33:04 JST from poster.place permalink
  16. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Friday, 26-Apr-2024 05:33:01 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • :blank:
    • J上校👮🇺🇦🏳️‍⚧️
    @i @colonelj

    Anyone got a quick summary for why SPC went down? Did the DB just grow out of control?
    In conversation Friday, 26-Apr-2024 05:33:01 JST from poster.place permalink
  17. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Wednesday, 24-Apr-2024 14:06:29 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • burner
    • DJ :debian: :coolcat: :colombia:
    • Vivi Nella Verita
    @burner

    cc @dj
    In conversation Wednesday, 24-Apr-2024 14:06:29 JST from poster.place permalink
  18. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Wednesday, 24-Apr-2024 14:06:27 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • burner
    • DJ :debian: :coolcat: :colombia:
    @dj @burner

    Ditto is a server thst is a nostr relay and sends posts to the mostr bridge. Soapbox is the UI you slap on top of it .

    This solution would be a one-stop-shop for nostr and the fediverse . Even has name verification
    In conversation Wednesday, 24-Apr-2024 14:06:27 JST from poster.place permalink
  19. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Wednesday, 24-Apr-2024 10:20:28 JST Vivi Nella Verita Vivi Nella Verita
    • burner
    @burner

    Check out what awesome thing Alex did

    https://ditto.poster.place

    If you switched to his Soapbox/Nostr relay called Ditto w Soapbox, you can use it to post to Nostr and Fedi all at the same time through the bridge.

    Probably a better plan than just leavinng akkoma to soapbox.pub?

    You can do both?
    In conversation Wednesday, 24-Apr-2024 10:20:28 JST from poster.place permalink

    Attachments

    1. No result found on File_thumbnail lookup.
      https://ditto.poster.place/
  20. Embed this notice
    Vivi Nella Verita (verita84eva@poster.place)'s status on Wednesday, 24-Apr-2024 10:20:27 JST Vivi Nella Verita Vivi Nella Verita
    in reply to
    • Alex Gleason
    • Dan_Hulson
    • burner
    @burner @alex @Dan_Hulson

    On Nostr, accounts are totally different. You get a public key and private key, so no. Those credentials work anywhere , decentralized.

    The database is completely different and more secure/private, so no.

    Nostr has DM's but I don't see that in Soapbox yet.
    In conversation Wednesday, 24-Apr-2024 10:20:27 JST from poster.place permalink
  • After
  • Before

User actions

    Vivi Nella Verita

    Vivi Nella Verita

    Tags
    • (None)

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          255499
          Member since
          15 Apr 2024
          Notices
          88
          Daily average
          0

          Feeds

          • Atom
          • Help
          • About
          • FAQ
          • TOS
          • Privacy
          • Source
          • Version
          • Contact

          GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

          Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.