For your viewing pleasure: Adam Wolk’s talk from #PosetteConf 2025 “Hitchhiker's Guide to Row-Level Security in #Citus"

https://youtu.be/uuQELBw8uDo

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).

Kommentar: Microsofts DocumentDB sucht Schutz bei der Linux Foundation

Die Linux Foundation nimmt DocumentDB unter ihre Fittiche. Das sichert der NoSQL-Datenbank die Offenheit, schützt sie aber auch vor rechtlicher Verfolgung.

https://www.heise.de/meinung/Kommentar-Microsofts-DocumentDB-sucht-Schutz-bei-der-Linux-Foundation-10620986.html?wt_mc=sm.red.ho.mastodon.mastodon.md_beitraege.md_beitraege&utm_source=mastodon

Crypto.com is hiring Senior Software Engineer (Golang/Ruby on Rails)

#golang #ruby #rubyonrails #cryptocurrency #kafka #postgresql #redis #seniorengineer
Kuala Lumpur, Malaysia
Full-time
Crypto.com

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-golang-ruby-on-rails-at-crypto-com-feb-28-2025-264120?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Microsoft donates DocumentDB to the Linux Foundation, ensuring vendor-neutral governance and cross-platform NoSQL database adoption.
https://linuxiac.com/microsoft-entrusts-documentdb-to-linux-foundation/

Today I learned about the Year 2038 problem, basically Y2K's lesser-known cousin

On 19 January 2038, some computers will run out of space to count time (because they store time as a 32-bit integer)
Result: clocks roll over into negative numbers, and software may think it's 1901
Plenty of time to fix… right?

https://en.m.wikipedia.org/wiki/Year_2038_problem

Thanks @mmeent_pg for dropping that gem on the #PostgreSQL slack!

#TIL #TimeTravelBug #2038Oops

Happy to share I'll be speaking at #FOSS4G Belgium on 25 September in Brussels!

My talk on PostgreSQL Upgrade Strategies will cover a challenge many of us know well: upgrading #PostgreSQL (especially with #PostGIS in the mix).

It often feels like opening Pandora's box, so many delay it. But upgrades are inevitable, and when done right they don't have to be painful.

Schedule: https://www.foss4g.be/en/schedule
https://www.linkedin.com/company/osgeo-be

See you in Brussels!

#postgresql 2025 GSOC: Mankirat Singh — ABI Compliance Reporting https://justatheory.com/2025/05/2025-gsoc/

Take a peek at Peter Farkas’s talk from #PosetteConf 2025 “From MongoDB to #Postgres: Building an Open Source Standard for Document Databases"

https://youtu.be/qCHrMsU842U

MoneyLion is hiring Lead Engineer (Backend)

#java #react #reactnative #springboot #api #aws #docker #kafka #kubernetes #mysql #postgresql #techlead
Kuala Lumpur, Malaysia
Full-time
MoneyLion

Job details https://jobsfordevelopers.com/jobs/lead-engineer-backend-at-moneylion-com-mar-26-2024-96ba76?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Guide on Setting Up Physical Streaming Replication in #PostgreSQL| Stormatics https://stormatics.tech/blogs/step-by-step-guide-on-setting-up-physical-streaming-replication-in-postgresql

#PostgreSQL Event Calendar, Reminder:

PG Armenia x Percona University Day 2025

Date: 2025-08-28T04:30:00Z - 2025-08-28T15:00:00Z
Location: Alek Manukyan 1, YSU 7th building 6th floor, Yerevan, AM

ICS file: https://ics.postgresql.life/6iln14na01jvb5m6npc3sl1rui3q2polp3167n00v789ouodjulfmh7bjc.ics

Unable to attend our Meetups? Missed one? Well no worries! Many of them have been recorded and are available on our YouTube channel!

https://www.youtube.com/watch?v=ndtN6vYhyUU

PostGIS 3.6.0rc1 https://postgis.net/2025/08/PostGIS-3.6.0rc1/ #gis #postgresql

pgAdmin 4 v9.7 Released
https://www.postgresql.org/about/news/pgadmin-4-v97-released-3120/

pgAdmin4 is not available through ports on FreeBSD, but can be jailed and installed via
https://pypi.org/project/pgadmin4/

Introducing Jimmy, one of our Organising Committee members!
The Committee is making sure our Riga conference delivers an outstanding PostgreSQL experience for everyone attending.

Riga, Latvia — October 2025
https://2025.pgconf.eu/

I extended my blog post about #PostgreSQL extensions with two extensions, that I missed to mention:
- pg_prewarm
- pgaudit

https://proopensource.it/blog/postgresql-extensions

Quelqu'un parmi les techs d'ici aurait un script vaultwarden avec postgresql utilisant traefik comme revers proxy sous docker...
Je bute et entrave pas grand chose à traefik...

Je suis sur un qnap et le reverse proxy est merdeux...

Voilà.

Le re toot rend le poils du dev sys soyeux et brillant...

Docker-compose adapté sous portainer

https://mariushosting.com/synology-install-vaultwarden-with-portainer/

#Docker #portainer #vaultwarden #postgresql #traefik

Merqui les techs

Invincible #Postgres Saga, episode 3...

(At least this didn't happen on production )

Earlier this week I tried to do some tests on my "wonderful" misconfigured testing environment. I had some errors here and there and they had to reveal themselves during my experiment...
To make everthing up-to-date I had to refresh data in my app, which uses #Patroni #Postgresql database. Of course it crashed when I tried to do it. It didn't turn down whole cluster, only that one server, and in theory it still had normal API access. I expected it to come back quickly after I fixed things breaking my servers. But for some reason it couldn't. It didn't even try, at least in any visible way.
Seriuosly it was the most disturbing thing there It should try to do something, right?!?
I tried to restart services in panic, without any result. It was late and I finished work for that day. Tired and worried I had to leave it stuck in "cannot reach consistent state" stage.

Next day I thought about doing force reinit or something to move it. But when I log into that server... Everything just worked
I checked logs... Almost nothing special, just like database was stuck and after ~14 hours suddenly started working. Only one line telling backup was restored.
Damn, what backup?!? Why I don't understand what it did?!? And why it needed so much time?!?

At least I had working environment and didn't had to wonder what to do. Maybe my first chaotic attempts to force it to work did more harm than good and I should just leave it...

Someone should write in docs, which API status means "just leave me alone, trying to fix things" It would be easier.

PostgreSQL Berlin: September Meetup

Tuesday, September 23, 2025

Amazon, Rocket Tower, Charlottenstraße 4 · Berlin, BE

https://www.meetup.com/postgresql-meetup-berlin/events/310242702/

Please pay attention to the Signup.