mastouille.fr est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Mastouille est une instance Mastodon durable, ouverte, et hébergée en France.

Administré par :

Statistiques du serveur :

586
comptes actifs

#PostgreSQL

7 messages7 participants1 message aujourd’hui

#PostgreSQL is hot as ever. Why is it like that? Besides the impressive engine, the critical thing is pluggable architecture as a first-class citizen. That opened database for new capabilities that maintainers didn't even think about.

That's also an entry point for the rich ecosystem.

If you'd like to see how this looks in practice, join me live next Tuesday (September 9th) at 4:00 PM UTC. Thanks to the invitation from the good folks at Particular (thanks, @danielmarbach) I'll have the next chance to preach about it! 😅

Sign up here: go.particular.net/e/27442/-ann

Oh well, it won't be just preaching, it'll be a really hands-on session. I hope that you're not allergic to SQL!

We'll code a simple, but real flow for: recording, reporting and alerting about the car fleet trips management.

That'll be a chance to showcase features such as:
- native PostgreSQL partitioning for efficient data storage management,
- How to compose plugins like Timescale for time series data, PostGIS for spatial data (GPS tracking etc.).
- In general, how can plugins cut down the time needed to deliver essential features
- Automate reporting with continuous aggregations without having to poll the database
- Stream database changes in real time by using logical replication as a push-notification system
- Detect issues as they happen, for example, spotting unusual fleet activity, without constant polling
- etc.

I'll also touch on how the hashtag#NServiceBus PostgreSQL relates to that!

So join me, it'll be fun even if you're using PostgreSQL on a daily basis!

Particular SoftwarePostgreSQL Superpowers in PracticePostgreSQL is more than a database — it can partition data, stream events, power maps, and even act like a message queue. Let’s build a real fleet management system that proves it. …
A répondu dans un fil de discussion

@id

I run both @prosodyim and @ejabberd. IMHO, both are easy to set up and maintain nowadays.

Just make sure that you use the file store for #Prosody (not an #RDBMS) and #PostgreSQL for #Ejabberd (not Mnesia) 🙂

Both have some minor features, that might be not present in the other, though. E.g. "great invitations", which are ATM only present in Prosody (but WiP for Ejabberd).

blog.prosody.im/great-invitati

blog.prosody.im · Great Invitations
Plus via Prosody IM

Is there any easy and friendly #PostgreSQL thing that allows restoring a database schema at a certain state (defined by a transaction, timestamp, whatever)?

I had aimed for pgMemento but its restore functions are totally not sufficient for me (losing indexes, grants, triggers, etc).

Ce que je redoutais le plus est passé : import de l'ancienne bdd dans #postgresql.
Je pense pas l'avoir dans les règles de l'art, mais ça a fonctionné du premier coup.
Demain je reconfigure le stockage pour que les fichiers soient de nouveau accessibles et j'agglomère mes notes pour compléter mon #wiki.
Ensuite on verra pour remettre en place les #backups parce que ça m'a bien servi sur ce coup là.
#nextcloud

Suite du fil

Au final je vais pas passer par #docker
Le soucis ne vient pas d'#alpinelinux qui serait ou se serait merdifié mais du #SSD système qui a pas loin de 15 ans.
Le système de fichiers est corrompu.

On repart avec du neuf, mais question:
J'ai des dumps en .sql de la BDD #postgresql.
Pour les injecter sur la nouvelle install #nextcloud, je dois quoi ?
Nom du user, de la bdd, le password, tout à la fois ?
Ou je peux juster créer un user, une bdd et injecter le dump dedans ?

Je maitrise pas trop.