Berkubernetus: "PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday."

#RIP #postgresql

https://m6n.io/@fuzzychef/112172393647826741

Upgraded the pod to #postgres 16.2 and it worked perfectly, because #Postgresql always works perfectly.

pg_analytics: Transforming Postgres into a Fast OLAP Database | #postgresql #olap #db #pg_analytics

Implementing System-Versioned Tables in Postgres | #postgresql #versioning

Implementing System-Versioned Tables in Postgres

There's no official support for system-versioned tables in Postgres yet, and the temporal extensions aren't supported on Azure/AWS/GCP. Let's implement it ourselves with 3 triggers and an index.

I will proceed to the database server upgrade later in the afternoon.

The following services will be unavailable for a while:

• diaspora
• Matrix

server blog

#podmin #freebsd #postgresql

#podmin

Posts tagged: podmin

This pod is now running #postgresql 16. Seems speedier.

#postgres #podmin

Now running #postgres 15.4. No issues. #postgresql

What happened to Vivaldi Social? | Thomas Pike’s other blog

https://thomasp.vivaldi.net/2023/07/28/what-happened-to-vivaldi-social/#tldr

Interesting postmortem. Be careful what you use your database read replica for.

#postgresql #mastodon

What happened to Vivaldi Social? | Thomas Pike’s other blog

A deep dive into the events of Saturday 8 July 2023, when user accounts started disappearing from the Vivaldi Social Mastodon instance.

Is there anywhere I can look for speeding up my pod? I know that I should be using Postegresql, but I did not know that in 2016! Is there any other "tweaks" I can make in the diaspora.yml config file to "increase speed"?

Thank you in advance...

#question #podmin #pod #sql #mysql #postgresql #diaspora

"After several months of development, FerretDB is now production-ready. We are excited to announce the general availability of FerretDB, a truly Open Source MongoDB alternative, built on PostgreSQL, and released under the Apache 2.0 license."

"MongoDB is no longer open source."

Hmm. Maybe just use PostgreSQL directly? I'm a fan of the relational model and static typing. I know, I know, opinionated.

FerretDB: A truly Open Source MongoDB alternative, built on Postgres

#solidstatelife #dbms #postgresql #mongodb

✅ Snapshot von VM #CentOS 8 Stream in Nürnberg erzeugt
✅ Neue VM aus dem Snapshot in Helsinki erzeugt
✅ Migration CentOS v8 Stream nach v9
✅ #postgresql migriert von v11 nach v15
✅ #synapse und #Apache laufen unverändert (auf #Python3.9 war ich schon)
✅ Erste Tests mit dem neun Server für #Matrix erfolgreich

6 Stunden - Uff!

Und wach!

Aus der Serie #EinmalMitProfis:

Successfully installed matrix-synapse-1.72.0

RuntimeError: Synapse requires PostgreSQL 11 or above.
*********************************************
 Error during initialisation:
    Synapse requires PostgreSQL 11 or above.
 There may be more information in the logs.
*********************************************

# dnf info postgresql | grep Version
Version      : 10.19

#Oops

Wie zur Hölle ging noch mal der Downgrade? Ah...
```

pip install matrix-synapse==1.71.0

Uff!

#Matrix #Synapse #Postgresql

If you are running #postgresql 14.3, you should upgrade to 14.4 to prevent data loss. #Diaspora works just fine with it.

Bumped the pod up to #postgres 14.3. No issues, as one would expect.

#postgresql #podmin #diaspora

#PostgreSQL Events in Europe • Tux Machines ⇨ http://www.tuxmachines.org/node/162119 #GNU #Linux #TuxMachines

#postgresql focusing on the wrong things... to help corporations remove dissenters https://www.postgresql.org/about/news/german-translation-of-community-code-of-conduct-posted-2414/ #psql #postgres

German Translation of Community Code of Conduct Posted

The PostgreSQL Community Code of Conduct Committee is pleased to announce that the German translation of the Code of Conduct …

"pg_back is a tool that can dump all your databases to files, with the configuration of the server and roles/tablespaces definitions." https://www.postgresql.org/about/news/pg_back-210-released-2413/ #postgresql #psql #postgres

#PostgreSQL : #Pgpool-II 4.3.1, 4.2.8, 4.1.11, 4.0.18 and 3.7.23 released. • Tux Machines ⇨ http://www.tuxmachines.org/node/161718 #psql #TuxMachines

PostgreSQL: PostgreSQL #JDBC 42.3.3 Released ⚓ https://www.postgresql.org/about/news/postgresql-jdbc-4233-released-2410/ ䷉ #postgresql

#PostgreSQL: pgAdmin 4 v6.5 Released • Tux Machines ⇨ http://www.tuxmachines.org/node/161466 #GNU #Linux #TuxMachines