@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@RagnarHeidar@mastodon.social avatar RagnarHeidar , to random

Another milestone for us at Icelandic Met Office 🎉

This week we launched a new site with forecasts and conditions, including recent avalanches. A major update was required in the background, migrating to and building the APIs and of course the website handled by our friends at Origo & Metall with maps from MapTiler

image/png
image/png
image/png

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@neptune22222@kolektiva.social avatar neptune22222 , to random

So... most gnome apps are failing to open on my debian sid daily driver. So... pgadmin4 won't open to remotely edit my company database. So... I have learned how to add a column to a table in my remote database using psql locally. Yup, I'm a hacker.

@allpurposemat@mastodon.gamedev.place avatar allpurposemat , to random

Ack, I dropped the wrong cluster last night and it nuked the databases for my and Synapse instances. Of course the backups stopped working a year ago 🙃

I still have a 57GB base dir from the database, but no WALs or anything else. Don't think it's recoverable, though... I fear I will be picking up the pieces for a few weeks at least.

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@musicman@mastodon.social avatar musicman , to random

This never goes anywhere maybe because I dont use tags so maybe today I will.

time so

I feel like folks know what AMA means but in case not: ask me anything.

Anything is supposed to mean anything but I can provide some topics:

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@markus@hachyderm.io avatar markus , to random

I love . It just works. It is extremely fast, because it’s just a local file access. It is very operationally and mentally simple, and it is extremely stable and well-tested. However, over my years of using it, there are just some things that I miss from the world of . So what happens if we just treat a local Postgres like SQLite? What does that mean? In this article, I’d like to expand on that idea.

https://www.maragu.dev/blog/what-if-we-treated-postgres-like-sqlite

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@cadusilva@bolha.one avatar cadusilva , to Admins do Fediverso Portuguese

Mantendo o banco de dados sempre em ótimo estado
fediadminbr@lemmy.eco.br icon Admins do Fediverso

Esses são comandos que executo semanalmente para manter o banco de dados tinindo:

# vacuumdb -v -z -j 4 -P 4 -d mastodon_production

# pg_repack --no-kill-backend -j 4 -d mastodon_production

O vacuumdb vai limpar o banco de dados e gerar estatísticas internas usadas pelo PostgreSQL para otimizar consultas.

Já o pg_repack permite remover o excesso de dados (bloat) e restaurar a ordem das tabelas e índices.

Isso ajuda a manter a instância rápida e bem azeitada, já que o banco de dados está bem azeitado também.

-j define o número de trabalhos, eu uso o mesmo número de CPUs.  
-P define os workers paralelos.

Documentação:

cc @fediadminbr

xmppbrasil ,
@xmppbrasil@mastodon.social avatar

@cadusilva fediadminbr@lemmy.eco.br icon Admins do Fediverso @fediadminbr você faz isso em algum horário específico de menor tráfego? O banco é ?