#libpq
これlibpqの問題だからPHPに限らずlibpqリンクしてる言語のは問題出るのでは…?
March 18, 2025 at 11:35 AM
11:41 down to 6:24. 🎉

· Switched from GitHub's hosted runners to Depot
· More aggressively excluded `mypy` paths.
· Moved to dedicated Redis action
· Removed unnecessary Node install
· Stopped manually installing `libpq`
July 7, 2024 at 8:07 PM
Fuzzing PostgreSQL at the front door 🔍Adam Wołk shows how it uncovers edge-case bugs in libpq and #PgBouncer. Learn how to build harnesses, harden Postgres networking code against real-world failures. p2d2.cz/en/talks/kno...

#libpq #Fuzzing #DatabaseSecurity #OpenSource #DBA #DeveloperTools
January 28, 2026 at 3:45 PM
On this day in PostgreSQL, 25 years ago: non-blocking mode support added to libpq
pgpedia.info/on-this-day-...
2000-01-18: non-blocking mode support added to libpq
On January 18th, 2000, non-blocking mode support was added to libpq
pgpedia.info
January 18, 2025 at 6:27 AM
Earlier this year, Daniele spoke at @pgconf.dev in Vancouver: "Psycopg: 20 years of mostly friendly coexistence with libpq" ❤️

The recording is now available to watch. Link in replies 👇

#PostgreSQL #Python #Psycopg #OpenSource
July 27, 2026 at 11:40 AM
Daniele Varrazzo reveals 20 years of mostly friendly Psycopg coexistence with libpq
May 20, 2026 at 5:34 PM
With supply-chain attacks on NPM rising, we disabled all install scripts (preinstall, postinstall, etc.) across our projects.

That broke builds for native modules, especially libpq, which we rely on heavily.

Our fix: pre-build libpq for Linux (x86_64 + arm64) and macOS, then publish it to NPM.
October 2, 2025 at 4:17 PM
Catch Adam Wolk (Microsoft) at #PosetteConf Livestream 1 (Tue 16 Jun) talking about "Fuzzing PostgreSQL" for a practical guide to fuzzing libpq effectively.

Join live to chat with Adam in the virtual hallway track on Discord.
posetteconf.com
June 16, 2026 at 4:15 PM
We're going to Vancouver! 🇨🇦 Our maintainer Daniele Varrazzo will be giving a talk at @pgconf.dev about libpq - the PostgreSQL client library at the heart of Psycopg - and how to get more out of PostgreSQL. Come say hi! 👋 #pgconfdev #PostgreSQL #Python #Psycopg #libpq #OpenSource #DevConference
May 15, 2026 at 10:02 AM
pg-connection-string 2.8.1 is out. Major features are better #typescript compatibility and a flag for libpq compatibility.

The libpq compatibility should make it easier to connect to managed postgres services that require TLS connections.

github.com/brianc/node-...
node-postgres/packages/pg-connection-string at pg-connection-string@2.8.1 · brianc/node-postgres
PostgreSQL client for node.js. Contribute to brianc/node-postgres development by creating an account on GitHub.
github.com
April 23, 2025 at 3:20 PM
SANS Stormcast Monday Feb 17th: Fake BSOD; Volatile IPs; Postgresql libpq SQL Injection; OAUTH Phishing
https://isc.sans.edu/podcastdetail/9326
February 17, 2025 at 1:25 AM
Enforce node-to-node mutual TLS for Citus on RHEL 9. Set sslmode=verify-full in node metadata so PostgreSQL/libpq validates hosts and ciphers distributed https://www.valtersit.com/vault/enforcing-strict-nodetonode-mutual-tls-encryption-for-citus--8dd8ea/
#citus #tls #ValtersIT
September 19, 2026 at 9:30 PM
📌 CVE-2026-6477 - Use of inherently dangerous function PQfn(..., result_is_int=0, ...) in PostgreSQL libpq lo_export(), lo_read(), lo_lseek64(), and lo_tell64() functio... https://www.cyberhub.blog/cves/CVE-2026-6477
CVE-2026-6477
Use of inherently dangerous function PQfn(..., result_is_int=0, ...) in PostgreSQL libpq lo_export(), lo_read(), lo_lseek64(), and lo_tell64() functions allows the server superuser to overwrite a client stack buffer with an arbitrarily-large response. Like gets(), PQfn(..., result_is_int=0, ...) st
www.cyberhub.blog
May 18, 2026 at 4:37 PM
Psycopg is the de facto standard Postgres adaptor for Python… and right now on the big stage at #PGConfdev, Daniele Verrazzo is presenting on Psycopf: 20 years of mostly friendly coexistence with libpq
May 20, 2026 at 5:47 PM
PostgreSQL at scale 🔐☸️ Zero-downtime upgrades (Anton Borisov, 10:15), IoT data pipelines with TimescaleDB (Michal Bartak, 11:10), cloud-native Postgres observability & containers (Peter Zaitsev, 15:35), and fuzzing libpq & PgBouncer for security (Adam Wolk, 16:30).

#PostgreSQL #PGDay #PPDD
January 26, 2026 at 12:58 PM
How does libpq from postgresql load SSL root certificates and how can you mirror that behavior in node.js?

Well, here's waaaaay too much information: https://github.com/mastodon/mastodon/pull/34528#discussion_r2083227645

Yes, I had to checkout the postgresql source code and reference the […]
Original post on hachyderm.io
hachyderm.io
May 10, 2025 at 9:31 PM
えーこんなのあったのか。PQescapeStringInternal の問題で主に `src/interfaces/libpq/fe-exec.c` の修正で対応した模様。PHP側もそこは信頼して使ってたんだろうなあ

PostgreSQLにあるSQLインジェクションの脆弱性が9年以上発見されずアメリカ財務省への侵入に使用されてしまう
PostgreSQLにあるSQLインジェクションの脆弱性が9年以上発見されずアメリカ財務省への侵入に使用されてしまう
2024年12月30日、「中国政府が支援する高度で持続的な脅威攻撃者」がアメリカ財務省の機密データを管理するシステムを侵害しました。この侵入にはPostgreSQLに9年以上存在していたのに誰も気付いていなかったSQLインジェクションの脆弱(ぜいじゃく)性が使用されたことが判明しており、ソフトウェアエンジニアのニック・アグリアーノ氏が記事にまとめています。
gigazine.net
March 18, 2025 at 10:43 AM
But do Package URLs actually work? I mean if I embed libpq what would be the correct purl for it -- there doesn't seem to be a scheme for the actual source without having a repository (might miss something). I am trying to use purls over CPE where possible due to all the false positives with CPEs :/
November 22, 2024 at 8:38 PM
🆕 Latest #PostgreSQL minor updates just landed - 𝟭𝟴.𝟭 | 𝟭𝟳.𝟳 | 𝟭𝟲.𝟭𝟭 | 𝟭𝟱.𝟭𝟱 | 𝟭𝟰.𝟮𝟬 | 𝟭𝟯.𝟮𝟯

Fixes 2 security vulnerabilities (including libpq allocation bug) and brings 50+ stability and perf improvements.

#Postgres #TechUpdates #OpenSource

www.postgresql.org/about/news/p...
PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released!
The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 18.1, 17.7, 16.11, 15.15, …
www.postgresql.org
November 13, 2025 at 3:23 PM
Hasql v2: the Native Era
AFAICT (and quoting the docs a bit) `pqi` reproduces the API surface of the `postgresql-libpq` package without any ties to libpq or any particular implementation of that API itself. hpgsql provides a much higher-level API than anything trying to replace postgresql-libpq - it’s more of a cousin to `postgresql-simple` and `hasql`. hpgsql has its own internal and lower-level APIs, of course, that I evolved while developing hpgsql to have the things I wanted, including for example interruption safety, thread safety and streams. They are very different from postgresql-libpq’s, and I honest don’t know how easily it could be retrofitted to a libpq-style API, though I think it should be possible (maybe with minor tradeoffs). My (biased and actually not that well informed about libpq) opinion, however, has been that the PostgreSQL ecosystem in Haskell would benefit from moving away from libpq-style APIs. We have wonderful abstractions and luxuries - from Streams to interruption safety and just plain pure code -, and though I didn’t look too deeply, while I was developing hpgsql it felt like not having the libpq-style APIs forced on me gave me a lot of freedom to achieve those goals, not to mention a lot of performance work (and there’s still a lot more of that coming!). I of course understand that asking other library authors to reimplement their libraries is a huge effort and risk, and that there’s a long way towards native postgres implementations to support all the auth methods and TLS encryption, so I applaud Nikita’s effort to make a call towards a common interface. And if I ever expose one from hpgsql, I’ll make sure to adapt it to `pqi`.
discourse.haskell.org
August 16, 2026 at 2:48 PM