Hacking the Postgres Wire Protocol
Link: https://pgdog.dev/blog/hacking-postgres-wire-protocol
Discussion: https://news.ycombinator.com/item?id=43693326
PgDogHacking the Postgres wire protocol
Recherches récentes
Options de recherche
#postgres
29 messages25 participants5 messages aujourd’hui
Hacking the Postgres Wire Protocol
PgDogHacking the Postgres wire protocol
We are excited to welcome Microsoft as a Supporter sponsor of PGDay Napoli 2025! We could not run this event without our sponsors.
2025.pgdaynapoli.orgSponsors – PGDay Napoli 2025Sponsorship opportunities at PGDay Napoli 2025!
@tchorix & I are presenting on data modeling within #PostgreSQL in a storytelling fashion at @posetteconf, a free virtual event hosted by #Microsoft that's all about #Postgres this June 10-12!
Want to tune in? Add the livestream to your calendar, or register (optionally) here: https://posetteconf.com/2025/talks/postgres-storytelling-cunning-schema-design-with-creative-data-modeling/ (or, wait until the recording is out after the event!)
Illustrations will be completed by Scarlett Riggs, who we are very excited to be working with.
This talk should be great for anyone that's looking to understand things from the perspectives of an application developer, and a seasoned database administrator; here, you'll be able to learn when it is best to handle logic within the database vs. the application!
Looking forward to seeing you there 
On June 12, join our CEO @c2main at 11:30 AM CEST for a FREE livestream @ @posetteconf regarding Pressure Stall Information within the world of #PostgreSQL.
Use this link to add the livestream to your calendar & optionally register, or follow us to get the recording after the conference when it becomes available!
posetteconf.com/2025/talks/resource-control-admission-i-have-a-date-with-my-psi/
Maintaining #Postgres for Modern Workloads https://xata.io/blog/maintainable-postgres-podcast
xata.ioMaintaining Postgres for Modern WorkloadsI was invited to the Maintainable Podcast hosted by Robby Russell. We talked about what makes software maintainable and naturally we also talked about Postgres.
A répondu dans un fil de discussion
@ascherbaum I started using #Postgres at version 7.0 so I lived through the transition, but somehow I didn't realize that it had happened.
I imagine countless other Postgres users must go through similar groundbreaking transitions and not realize
A répondu dans un fil de discussion
@ascherbaum I think what actually happened before WAL was developed, was that we'd keep a list of files modified by the transaction and run fsync on them at commit time
#postgres
I recently leaned on an #LLM to help me get data out of a legacy database. The key was a multi-step prompt that took an existing schema and compressed it. That allowed me to build a chat bot that understood and could generate SQL for the answers I was seeking.
https://www.joecotellese.com/posts/2025-04-10-accelerate-database-understanding-with-llms/
Joe Cotellese · How I Used LLMs to Help a Team Understand a Legacy Database in HoursSee how a fractional VP of Engineering used LLMs to decode a legacy database fast.
Suite du fil
I ended up adding an SSH user called `postgreslogs` which serves as a way to SSH directly into the logs using:
- A `ForceCommand` SSH daemon config for the user
- A `sudoer.d` config to allow postgreslogs to elevate (i.e. sudo) to postgres (the DB admin account) without a password
Works really nicely! All you need to do to see the logs is to `ssh postgrelogs@postgreshost.proxmox` or similar!
Join us for “Fun with Postgres High Availability Poker” with David Pitts and Teresa Lopes at Pg Day Chicago 2025!
@PostgreSQL #postgres #conference
Microsoft MVP Taiob Ali will share his talk on "Azure Database for #PostgreSQL: 15 Essential Standards for Compliance and Security" at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @1:00pm PDT (UTC-7)) 
Find out more: https://posetteconf.com/2025/talks/azure-database-for-postgresql-15-essential-standards-for-compliance-and-security/
Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
Vector 0.46.0 now includes a #Postgres sink!
It's time to send my logs to TimescaleDB 
vector.devVector v0.46.0 release notes
We're happy to see our own Frédéric has been interviewed as a #PostgresFriend! See his interview with @ascherbaum on #PostgreSQLLife:
PostgreSQL Person of the Week · Interview with: Frédéric Delacourt | PostgreSQL Person of the WeekPostgreSQL Person of the Week interview with Frédéric Delacourt, published 07.04.2025, interview conducted by Andreas Scherbaum
Learn about ”CloudNativePG 101” with Gabriele Quaresima at Pg Day Chicago 2025!
https://postgresql.us/events/pgdaychicago2025/sessions/session/1867-cloudnativepg-101/
@PostgreSQL #postgres #conference
Our online affiliated PUGs are looking for speakers! If you aren’t local to an in-person PUG, we can put you in touch with the organizers of Postgres for All and SF PUG. Contact us today and grow your reputation as a speaker!
Learn more: https://posetteconf.com/2025/talks/migrating-from-oracle-to-azure-database-for-postgresql-seamlessly/
We hope to see you today at noon PST for "Where do Performance Cliffs Come From?" with Tomas Vondra! RSVP now!
https://www.meetup.com/postgresql-1/events/306484787/?eventOrigin=group_events_list
