--- title: Best PostgreSQL posts — June 2026 | daily.dev description: The most upvoted PostgreSQL posts from June 2026, curated by the daily.dev community. canonical: https://daily.dev/sources/postgres/best-of/2026/06 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/postgres/best-of/2026/06 og:type: website og:site_name: daily.dev og:title: Best PostgreSQL posts — June 2026 | daily.dev og:description: The most upvoted PostgreSQL posts from June 2026, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of PostgreSQL — June 2026 1. 1 [](https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu "New Postgres Language Server: postgres-lsp") Article PostgreSQL · 11w New Postgres Language Server: postgres-lsp postgres-lsp is a new Language Server Protocol implementation for PostgreSQL SQL and PL/pgSQL, built on tree-sitter-postgres. It brings IDE-grade features to .sql files including diagnostics, semantic tokens, go-to-definition, find references, context-aware completion, signature help, rename refactoring, code actions, and SQL formatting with multiple style presets (river, mozilla, dbt, gitlab, etc.). All parsing is backed by real PostgreSQL grammar rather than regex heuristics. 46 3 2. 2 [](https://daily.dev/posts/pgadmin-4-v9-16-released-43lcqxnyc "pgAdmin 4 v9.16 Released") Article PostgreSQL · 12w pgAdmin 4 v9.16 Released pgAdmin 4 v9.16 has been released with 64 bug fixes and new features, most notably patching seven security vulnerabilities (CVE-2026-12044 through CVE-2026-12050). Critical fixes include SQL injection in dialog templates and a named restore point endpoint, an AI Assistant read-only transaction bypass enabling RCE via COPY TO PROGRAM, unauthenticated SQL Editor endpoints with a pickle deserialization sink, stored XSS allowing credential exfiltration, HTML injection in cloud deployment modules, and an open redirect in the MFA flow. New features include server-color-coded panel headers, middle-click tab closing, configurable Helm chart security contexts, and TOAST tuple target support in Materialized View dialogs. pgAgent has been deprecated and will be removed within six months. 35 2 3. 3 [](https://daily.dev/posts/pgfmt-2-1-in-place-formatting-and-pg-dump-compatible-output-iujcxxifh "pgfmt 2.1: in-place formatting and pg_dump-compatible output") Article PostgreSQL · 12w pgfmt 2.1: in-place formatting and pg\_dump-compatible output pgfmt 2.1 introduces two major features: in-place file formatting via the --inplace/-i flag (writes formatted SQL back to source files while preserving permissions, supports multiple files), and a new --style pg\_dump mode that reproduces PostgreSQL's ruleutils.c deparser layout. The pg\_dump style is byte-idempotent on genuine deparser output, making it useful for diffing migrations against what PostgreSQL actually stores. The release also expands SQL and PL/pgSQL formatting coverage, fixes correctness bugs including dropped typed string literals like INTERVAL '2 days', and is now installable via Homebrew. 28 [See all PostgreSQL archives](/sources/postgres/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/postgres/best-of/2026/06#page","url":"https://daily.dev/sources/postgres/best-of/2026/06","name":"Best PostgreSQL Posts — June 2026","description":"The most upvoted PostgreSQL posts from June 2026, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/postgres/best-of/2026/06#items","numberOfItems":3,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/new-postgres-language-server-postgres-lsp-yok0fzzyu","name":"New Postgres Language Server: postgres-lsp"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/pgadmin-4-v9-16-released-43lcqxnyc","name":"pgAdmin 4 v9.16 Released"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/pgfmt-2-1-in-place-formatting-and-pg-dump-compatible-output-iujcxxifh","name":"pgfmt 2.1: in-place formatting and pg_dump-compatible output"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/postgres/best-of"},{"@type":"ListItem","position":5,"name":"June 2026"}]}]} ```