So, es ist soweit, ich suche einen Managed #Kubernetes Anbieter in #Österreich oder sonst wo in der #EU. Google hab ich schon bedient, aber wenn jemand persönlich gute Erfahrung mit einem Anbieter hat, würde mir das weiterhelfen. Managed #Postgres und #Kafka dabei gibt Pluspunkte ;)
Gerne Retoot.

The community asked: "Is NotebookLlaMa ever going to get a space where we can see all our previously processed documents?"
And we responded with a new feature: all your documents are now in one place - a full-fledged document management UI: watch the demo below
And that is not the only good news: the information about processed documents lives on your computer, since it is stored in a local #Postgres database!

Nous sommes convaincus que les entreprises du monde entier peuvent bénéficier du projet open source #IvorySQL pour une transition fluide d'Oracle vers #PostgreSQL. Profitez de la puissance de la gestion des données open source avec l'assistance, les options consultatives, et la formation de Data Bene ; nous sommes là pour vous aider avec des décennies d'expérience dans Postgres et une participation active au projet #IvorySQL.

The #PostgreSQL 18 beta2 #Docker container are available.
If you haven't started testing against #Postgres 18, now is your chance.
https://hub.docker.com/_/postgres/

We made Postgres writes faster, but it broke replication

Link: https://www.paradedb.com/blog/lsm_trees_in_postgres
Discussion: https://news.ycombinator.com/item?id=44633933

We made Postgres writes faster, but it broke replication
https://www.paradedb.com/blog/lsm_trees_in_postgres
#ycombinator #Postgres #search #analytics #ETL #Elasticsearch #OLAP

We made Postgres writes faster, but it broke replication

https://www.paradedb.com/blog/lsm_trees_in_postgres

Paperless-ngx:

Inzwischen wird ja die Postgres-Version 17 verwendet.

Falls jemand schon länger kein Update gemacht hat: Noch mal ein (1-Klick)-Backup vor dem Update durchführen.

Ansonsten: Wenn man Paperless-ngx so installiert hat, wie ich es vorgeschlagen habe, kann man sich bequem zurücklehnen und das Update auf Version 2.17.1 wie gewohnt durchführen. Neue Datenbankversion usw. passiert alles automatisch.

AWS open-sourced Postgres active-active replication extension

Link: https://github.com/aws/pgactive
Discussion: https://news.ycombinator.com/item?id=44580257

AWS open-sourced Postgres active-active replication extension

https://github.com/aws/pgactive

#HackerNews #AWS #Postgres #open-source #active-active #replication #extension #HN #Tech #News

How are people here running #postgres in #highavailability mode when #selfhosting?

When Sigterm Does Nothing: A Postgres Mystery

Link: https://clickhouse.com/blog/sigterm-postgres-mystery
Discussion: https://news.ycombinator.com/item?id=44567888

Welcome Fujitsu Enterprise Postgres as a Gold sponsor of PGConf.EU 2025 in Riga!

https://2025.pgconf.eu/sponsors/

When Sigterm Does Nothing: A Postgres Mystery

https://clickhouse.com/blog/sigterm-postgres-mystery

Install and run a PostgreSQL database locally on Linux, MacOS or Windows. PostgreSQL can be bundled with your application, or downloaded on demand.

This library provides an embedded-like experience for PostgreSQL similar to what you would have with SQLite.

https://github.com/theseus-rs/postgresql-embedded

I was not very satisfied with the idea of running a separate #postgres instance for #immich (especially since I already have one running on the host), but with the recent migration to vectorchord I was kind of forced to (tried to install a bunch of .debs, left a mess that would fail to start, ran out of FAFO time).

It turns out that there was nothing to be afraid of, the Postgres container only uses 60MB of RAM and is sitting mostly idle.

*Takes a deep breath*

#MariaDB might be the best general database engine ever and it sucks that the for-profit company using the name kept stepping on rusty rakes over and over again so that people in suits who can't distinguish the corp from the foundation pushed for other platforms.

Side note: #PostgreSQL, I want to love you, but I have so many similar feelings about you as I do about coding in rust. You're too pedantic for your own good.

In testing a postgres upgrade (13->15) for our mastodon-servcer, I run into a fatal error 'Your installation contains user-defined objects that refer tointernal polymorphic functions with arguments of type "anyarray" or "anyelement". Haven't been able to find a fix for this online, and there seems to be no logfile to pinpoint the cause. Anyone have any suggestions on how to fix this? #techquestion #mastoadmin #postgres [Edit: solved, see reply]

Postgres LISTEN/NOTIFY does not scale

Link: https://www.recall.ai/blog/postgres-listen-notify-does-not-scale
Discussion: https://news.ycombinator.com/item?id=44490510