Elektrine
Log in Register

#postgresql

51 posts · Last used 4d

Back to Timeline
alsternerd
alster @alsternerd@akkoma.alster.space · 4d ago
Alter Verwalter, dass PostreSQL die Datenbank migrationen nur einem Kern von 8 laufen lässt, lässt den Spaß dann halt 15 Minuten dauern. #Akkoma #PostgreSQL
0
1
0
xrobau
Rob Thomas [Admin m.au] @xrobau@mastodon.au · 5d ago
Sorry about that long-ish outage, but we were YET AGAIN getting smashed by AI bots. I have given up fighting them, and I'm just scaling up until #mastodonAU can handle the load. This time the #PostgreSQL database was running at a load of 100+ because it was disk IO bound. I did *try* to live migrate it, but it was just insanely slow so I made the call to shut it down (hence the 'Something went wrong' errors) and move it offline. It's moved. Now it's running on a pure SSD-only backing store, which hopefully will handle everything the #AI scrapers throw at us. I'll be doing the same thing with #MastodonNZ too, shortly (but hopefully without the outage, as that's a much more lightweight instance) I also really need to fix the status page that comes up when mau is down.
7
1
6
jobsfordevelopers
Jobs for Developers @jobsfordevelopers@mastodon.world · Aug 07, 2026
Aircall is hiring Front End / Fullstack Engineer - Messaging Team 🔧 #ruby #typescript #react #node #api #graphql #aws #cicd #postgresql 🌎 Madrid, Spain ⏰ Full-time 🏢 Aircall Job details https://jobsfordevelopers.com/jobs/front-end-fullstack-engineer-messaging-team-at-aircall-io-may-26-2026-30b321?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring
0
0
0
DailyCyberSecurity
Daily CyberSecurity @DailyCyberSecurity@infosec.exchange · Jul 31, 2026
A PHP SQL injection flaw, CVE-2026-17543, was patched alongside two memory bugs. Update to PHP 8.2.33, 8.3.33, 8.4.24, or 8.5.9 now. #PHP #SQLInjection #CVE202617543 #PostgreSQL #Vulnerability #InfoSec https://securityonline.info/php-sql-injection-cve-2026-17543/?utm_source=mastodon&utm_medium=jetpack_social
0
0
0
upscene
Upscene Productions @upscene@mstdn.business · Jul 30, 2026
Database Workbench 7.0.5 released ✅ #AI Assistant improvements ✅ Improved XML data export ✅ Much faster ODS and XLS data import ✅ Improved Welcome Window Read more ➡️ https://www.upscene.com/news/item/20260722 #Firebird #MySQL #MariaDB #Oracle #PostgreSQL #SQLServer #InterBase #SQLite #NexusDB #databasedevelopment #DatabaseWorkbench #AIDevelopment
0
0
0
jpostma
Jeroen Postma 🇪🇺 @jpostma@mastodon.clusterfucks.nl · Jul 30, 2026

Upgraded the Mastodon backend postgresql server from 14 to 18 with pgautoupgrade. Found out that I had some uniqueness violations (possibly due to collation changes) that needed some manual DB operations to merge accounts and remove duplicate entries before I could run tootctl maintenance fix-duplicates. Then used pg_repack to remove bloat and finally used REINDEX to fix the last bits.

Everything's fresh and smooth again!

#MastoAdmins #PgAutoUpgrade #PgRepack #postgresql #postgres

3
0
1
upscene
Upscene Productions @upscene@mstdn.business · Jul 29, 2026
"Using #AI to Update Audit Triggers After Schema Changes" Generating an audit trigger is only the beginning. As a database evolves, tables change, new columns are added, and existing audit triggers need to evolve with them. This is another area where AI can save developers valuable time. https://www.upscene.com/articles/article/8/ai-to-update-triggers-after-database-schema-changes #databasedevelopment #DatabaseWorkbench #sql #AIDevelopment #sqlite #sqlserver #PostgreSQL #FirebirdSQL #mysql #MariaDB #sqlserver #oracle #InterBase
0
0
0
dima
Dima @dima@dol.social · Jul 28, 2026
It has been a while since I wrote a proper long guide about something I actually love doing. In September 2025 I wrote up how to run Mastodon on Kubernetes. That blog is gone, the guide survives only in the Web Archive. A text about backups that exists as somebody else's copy. At least it stayed on topic. So I rewrote all of it against Mastodon 4.6. The part I got wrong the first time was the most important one: Postgres as a Deployment with a PVC next to it. Kubernetes sends SIGTERM, Postgres reads that as a smart shutdown and waits for every client to disconnect. Sidekiq never does. Thirty seconds later, SIGKILL and a crash recovery. CloudNativePG and continuous WAL archiving now, RPO down from 24 hours to minutes. Still no Helm, everything by hand, because I want to understand what runs. My own instance came off Kubernetes in March, purely on cost. This is the config as it last ran. https://www.dol.ch/en/blog/mastodon-4-6-kubernetes?=s1 #Kubernetes #PostgreSQL #CloudNativePG #SelfHosting #DevOps #Mastodon #Blog #Fediverse
3
1
6
dima
Dima @dima@dol.social · Jul 28, 2026
It has been a while since I wrote a proper long guide about something I actually love doing. In September 2025 I wrote up how to run Mastodon on Kubernetes. That blog is gone, the guide survives only in the Web Archive. A text about backups that exists as somebody else's copy. At least it stayed on topic. So I rewrote all of it against Mastodon 4.6. The part I got wrong the first time was the most important one: Postgres as a Deployment with a PVC next to it. Kubernetes sends SIGTERM, Postgres reads that as a smart shutdown and waits for every client to disconnect. Sidekiq never does. Thirty seconds later, SIGKILL and a crash recovery. CloudNativePG and continuous WAL archiving now, RPO down from 24 hours to minutes. Still no Helm, everything by hand, because I want to understand what runs. My own instance came off Kubernetes in March, purely on cost. This is the config as it last ran. https://www.dol.ch/en/blog/mastodon-4-6-kubernetes #Kubernetes #PostgreSQL #CloudNativePG #SelfHosting #DevOps #Mastodon #Blog #Fediverse
0
0
0
fabianlucchi
IT-Awareness, Fabian Lucchi :donor: @fabianlucchi@infosec.exchange · Jul 28, 2026
RE: https://mastodon.social/@CuratedHackerNews/116995302796538950 Addictive read ! I loved it, deep drive in rdbms flaws and features ! Thank you for this incredible technical analysis. #postgresql #oracle #mongodb #sqlserver #mysql #cache #internals
Quoting
Curated Hacker News @CuratedHackerNews@mastodon.social
PostgreSQL's MVCC is bad. So is everyone else's https://boringsql.com/posts/mvcc-bad-bad/ #postgresql
Open quoted post
0
0
0
niclas
Niclas @niclas@infosec.exchange · Jul 24, 2026
Since March 2026, I have been running honeypots on the internet to collect data and analyze attack patterns. The amount of data stored in the log database has steadily increased over the past few months and has now reached 70 GB of raw logs. I may need to consider a better archiving strategy, especially since I am thinking about adding a T-Pot instance, which would significantly increase the load on the current database setup. #honeypot #postgresql #sysadmin #cybersecurity #blueteam
1
0
1
benjamingeer
Benjamin Geer @benjamingeer@piaille.fr · Jul 21, 2026
Candidature rejetée, après deux entretiens, parce que l'entreprise «s'oriente vers une adoption forte de l'IA dans ses pratiques de développement, une direction qui ne semble pas alignée avec vos attentes à ce stade». Est-ce qu'il y a encore des éditeurs de logiciels en France qui sont prêts à embaucher un développeur qui préfère écrire lui-même son code ? #GetFediHired #Rust #Scala #Python #PostgreSQL
58
15
116
europlus
europlus :autisminf: @europlus@social.europlus.zone · Jul 19, 2026
If I wanted to run a PostgreSQL query on my masto server which shows my personal home timeline as the result, does anyone have any pointers to guides or even such a query itself? Please boost for reach. #MastoAdmin #SelfHosting #MastoAdmins #PostgreSQL
0
2
1
rincewind
Frank @rincewind@unseen-university.social · Jul 13, 2026
Neuer Quick-Tip im Blog: Distro-Upgrade durch, alles läuft – denkt man. Dann räuspert sich PostgreSQL bei jeder Verbindung: Sortierfolgen-Version stimmt nicht. 🙃 Der glibc-Sprung schlägt wieder zu, quasi Teil 2 nach dem charlock_holmes-Drama. Spoiler: Die Warnung einfach wegdrücken wäre die schlechteste Idee, erst reindizieren! https://just-stuff.blog/postgresql-collation-version-mismatch-glibc-upgrade/ #PostgreSQL #Debian #Trixie #Linux #SelfHosting #Mastodon
3
0
8
psycopg
Psycopg @psycopg@fosstodon.org · Jul 17, 2026
We've launched a GitHub Sponsors page for Psycopg 🐘🐍 Psycopg has been the standard PostgreSQL adapter for Python for 20 years. Your sponsorship goes directly towards maintaining Psycopg 2 and Psycopg 3, and keeping the project active and up to date. Sponsors are also listed on our new sponsors page on the Psycopg website. Links in replies 👇 #PostgreSQL #Python #Psycopg #OpenSource #FOSS #DataEngineering
8
0
15