pgbadger
sydent
pgbadger | sydent | |
---|---|---|
6 | 710 | |
3,386 | 282 | |
- | 1.8% | |
7.9 | 6.5 | |
2 months ago | 25 days ago | |
Perl | Python | |
PostgreSQL License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pgbadger
-
Site down due hosted on digitalocean
It might also help to use pgbadger or something similar to process your postgres logs and see whether some event is aligned with your outages.
-
SQL: 2023 Has Been Released
Interestingly, when a place does get to the point where the single instance has capacity issues (after upgrading to EPYC and lots of flash drives) then other non-obvious stuff shows up too.
For example, at one place just over a year ago they were well into this territory. One of weird problems for them was with pgBadger's memory usage (https://github.com/darold/pgbadger). That's written in perl, which doesn't seem to go garbage collection well. So even on a reporting node with a few hundred GB's of ram, it could take more than 24 hours to do a "monthly" reporting run.
There wasn't a solution in place at the time I left, so they're probably still having the issue... ;)
- Moving from Oracle to Postgres, what should I know?
-
What are the top 3 most useful things that you have hosted over the years?
First of all I used a profiler (pgbadger and netdata) to figure out where the lags were coming from. I then tried the usual stuff (increasing shared_buffers, max_wal_size, min_wal_size from their ultra low defaults), but the biggest performance gain came from moving the database from eMMC to a mechanical hard drive :-D
-
Best way to find queries that might benefit from indexes.
Look into PgBadger (a log parser/analyser): https://github.com/darold/pgbadger
sydent
- Discord is nuking Nintendo Switch emulator devs and their entire servers
-
Qilin: A Starter Project Template For Every Open Source Project
GitHub Discussions can also be a great place for support as long as these are regularly monitored. Another option along the same lines is Discourse and the Open Source Matrix which is used by quite a few Open Source and community-based projects.
-
A man has been swatted 47 times for making a joke about Norm Macdonald
Tangential: the article notes that Telegram is an “encrypted messaging app”. While this is technically true, it's worth keeping in mind that it's not end-to-end encrypted, so it's less secure in that regard than, say, Signal or even WhatsApp. Telegram does have opt-in end-to-end encrypted one-on-one chats, but those are very inconvenient to use.
For a properly encrypted chat app, including group chats (opt-in), try Matrix instead: https://matrix.org/
- Matrix is a decentralized messaging ecosystem worth checking out
-
Launching Default End-to-End Encryption on Messenger
I'd love something like the Matrix [0] data model (JSON messages aggregated in an eventually-consistent chatroom CRDT) transmitted over something like simplex for metadata resistance.
[0] https://matrix.org
-
Meta is pulling the plug on Messenger chats on Instagram
Trillian mod here. There's this new thing called Beeper, works on matrix.org. It's not as the good old times, but I'm currently using whatsapp, FB messenger, discord, telegram, signal, imessage and a few more. It's not Cerulean experience, but it's... slowly improving.
- Show HN: Beeper Mini – iMessage Client for Android
- Um pouco da realidade de Copacabana - principalmente aos finais de semana
- O Fazueli está destruindo o Sul do Brasil
-
Connect to Element One in Element X?
I'm trying to change my account provider from "matrix.org" to whatever Element One needs, and for the life of me I just don't understand what values I have to put where to be able to log in. I tried `element.io`, which takes me to sso.element.io but this doesn't seem like the right thing (no credentials work as I expect.
What are some alternatives?
pgaudit_analyze - PostgreSQL Audit Analyzer
matrix-docker-ansible-deploy - 🐳 Matrix (An open network for secure, decentralized communication) server setup using Ansible and Docker
Mailcow - mailcow: dockerized - 🐮 + 🐋 = 💕
matrix-synapse - The Matrix Synapse homeserver for Docker / k8s - deprecated, use upstream
minion - :octopus: Perl high performance job queue
Mattermost - Mattermost is an open source platform for secure collaboration across the entire software development lifecycle..
postgresqltuner - Simple script to analyse your PostgreSQL database configuration, and give tuning advice
apprise-api - A lightweight REST framework that wraps the Apprise Notification Library
Octopussy - Octopussy - Open Source Log Management Solution
Synapse - Synapse: Matrix homeserver written in Python/Twisted.
apache2buddy - apache2buddy
Mastodon - Your self-hosted, globally interconnected microblogging community