ads' corner

certbot on Debian Bookworm fails with: The peer didn't know the key we used

Was setting up a new Debian Bookworm system in my home environment. So far I was not using certificates at home, and wanted to change this along the way, using Let's Encrypt. Since the IP-addresses here are RFC1918, I can't use the http01 challenge, and have to resort to dns01 challenges. On Debian Bookworm, using certbot, this fails reproducible.

PostgreSQL February Meetup in Berlin

On February 6th, 2024, we had the PostgreSQL February Meetup in Berlin. Ryan Booz presented about Super-powered Data Transformation in PostgreSQL. Artur Zakirov presented about pg_repack.

PGSQL Phriday #0014 - PostgreSQL Events

Pavlo Golub is hosting this month's PGSQL Phriday. The topic is 'PostgreSQL Events'.

PGSQL Phriday #008 – pg_stat_statements

The topic for this month's PGSQL Phriday blogging challenge is: pg_stat_statement. And Michael Christofides gave me a perfect opener in his invitation. For anyone who doesn't know, I'm running a weekly interview series with people from the PostgreSQL community. It's called 'PostgreSQL Person of the Week'.

PGSQL Phriday #007 – Triggers for tracking changes in a table

This month's #PGSQLPhriday is hosted by Lætita Avrot, and she asks about triggers.

PGSqlPhriday #006: One Thing You Wish You Knew While Learning PostgreSQL: psql commands

For this month's #PGSQLPhriday, Grant Fritchey asks: What is the one thing you wish you knew while you learn PostgreSQL.

Relational and Non-relational Data: PGSQL Phriday #005

Ryan Lambert asks in this month's PGSQL Phriday about non-relational data storage in PostgreSQL

PGSQL Phriday #004: PostgreSQL and Software Development

Henrietta Dombrovskaya asks about Software Development and PostgreSQL. That's a very broad topic. Not being a big developer for myself, and only occasionally submitting patches here and there, I nevertheless have a vast amount of data available on the topic: the 'PostgreSQL Person of the Week' interviews! There are a few questions in the interviews which relate to this topic.

PGSQL Phriday #003: What is the PostgreSQL Community to me

Pat Wright is running this month’s #PGSQLPhriday, and the topic is 'What is the PostgreSQL Community to you?'

PGSQL Phriday #002 Summary: PostgreSQL Backup and Restore

Last week for 'PGSQL Phriday': Describe how you do backups for your PostgreSQL databases.