Sponsor of the Day:
Jerkmate
https://www.postgresql.org/about/news/pg_ash-v1-active-session-history-for-postgresql-3242/
PostgreSQL: pg_ash v1 - Active Session History for PostgreSQL
pg_ash samples `pg_stat_activity` once per second via `pg_cron`, stores encoded snapshots in partitioned tables, and provides 32 SQL functions for …
postgresql pgactive sessionashv1history
https://www.postgresql.org/about/news/pg_dbms_job-v20-released-3278/
PostgreSQL: pg_dbms_job v2.0 released
Antananarivo, Madagascar - April 19, 2026 ## PostgreSQL DBMS_JOB compatibility extension pg_dbms_job is a new PostgreSQL extension to create, manage …
v2 0 releasedpostgresql pgdbmsjob
https://www.postgresql.org/about/news/pg_textsearch-v10-3264/
PostgreSQL: pg_textsearch v1.0
Hi folks, I'm delighted to announce the general availability of pg_textsearch v1.0. This is an open source extension (Postgres license) …
postgresql pgv1 0
https://www.postgresql.org/about/event/pg-data-2026-2551/
PostgreSQL: PG DATA 2026
pg data 2026postgresql
https://www.postgresql.org/docs/current/pgbuffercache.html
PostgreSQL: Documentation: 18: F.25. pg_buffercache — inspect PostgreSQL buffer cache state
F.25. pg_buffercache — inspect PostgreSQL buffer cache state # F.25.1. The pg_buffercache View F.25.2. The pg_buffercache_numa View F.25.3. The...
postgresql documentation 18f 25pginspectbuffer
https://pgxn.org/dist/pg_clickhouse/
pg_clickhouse: Query ClickHouse databases from PostgreSQL / PostgreSQL Extension Network
Provides a Foreign Data Wrapper and other interfaces for easy and efficient access to ClickHouse databases, including pushdown of WHERE, JOIN, and aggregates...
postgresql extension networkpg clickhousequerydatabases
https://www.postgresql.org/docs/devel/auth-pg-hba-conf.html
PostgreSQL: Documentation: devel: 20.1. The pg_hba.conf File
20.1. The pg_hba.conf File # Client authentication is controlled by a configuration file, which traditionally is named pg_hba.conf and is stored …
documentation devel 20conf filepostgresql1pg
https://www.postgresql.org/docs/current/app-pgdump.html
PostgreSQL: Documentation: 18: pg_dump
pg_dump pg_dump — export a PostgreSQL database as an SQL script or to other formats Synopsis pg_dump [connection-option...] [option...] [dbname] …
postgresql documentation 18pg dump
https://www.postgresql.org/docs/current/catalog-pg-authid.html
PostgreSQL: Documentation: 18: 52.8. pg_authid
52.8. pg_authid # The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and …
postgresql documentation 1852pgauthid
https://www.postgresql.org/docs/current/app-pgreceivewal.html
PostgreSQL: Documentation: 18: pg_receivewal
pg_receivewal pg_receivewal — stream write-ahead logs from a PostgreSQL server Synopsis pg_receivewal [option...] Description pg_receivewal is used to stream...
postgresql documentation 18pg
https://www.percona.com/blog/postgresql-oidc-authentication-with-pg_oidc_validator/
PostgreSQL OIDC Authentication with pg_oidc_validator
Learn how PostgreSQL 18 adds OAuth-based authentication and how Percona’s pg_oidc_validator enables seamless SSO integration using OpenID Connect.
oidc authenticationpostgresqlpgvalidator
https://pgsupport.dk/
PG Support: PostgreSQL Professional Services & Support
PG Support are PostgreSQL experts with decades of experience. Our consultants will help you acheive success.
postgresql professionalpgsupportservices
https://www.postgresql.org/support/security/CVE-2023-5870/
PostgreSQL: CVE-2023-5870: Role "pg_signal_backend" can signal certain superuser processes
postgresql cve 20235870rolepgsignal
https://www.postgresql.org/docs/18/pgupgrade.html
PostgreSQL: Documentation: 18: pg_upgrade
pg_upgrade pg_upgrade — upgrade a PostgreSQL server instance Synopsis pg_upgrade -b oldbindir [-B newbindir] -d oldconfigdir -D newconfigdir [option...]...
postgresql documentation 18pg
https://www.depesz.com/2020/12/21/waiting-for-postgresql-14-pg_stat_statements-track-time-at-which-all-statistics-were-last-reset/
Waiting for PostgreSQL 14 – pg_stat_statements: Track time at which all statistics were last reset....
pg stat statementspostgresql 14track timewaitingstatistics
https://www.postgresql.org/docs/current/pgwaldump.html
PostgreSQL: Documentation: 18: pg_waldump
pg_waldump pg_waldump — display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster Synopsis pg_waldump [option...] [startseg …
postgresql documentation 18pg
https://pgxn.org/dist/pg_clickhouse/0.1.4/
pg_clickhouse 0.1.4: Query ClickHouse databases from PostgreSQL / PostgreSQL Extension Network
Provides a Foreign Data Wrapper and other interfaces for easy and efficient access to ClickHouse databases, including pushdown of WHERE, JOIN, and aggregates...
pg clickhouse 0postgresql extension network1 4querydatabases
https://www.postgresql.org/docs/current/pgfreespacemap.html
PostgreSQL: Documentation: 18: F.27. pg_freespacemap — examine the free space map
F.27. pg_freespacemap — examine the free space map # F.27.1. Functions F.27.2. Sample Output F.27.3. Author The pg_freespacemap module provides a …
postgresql documentation 18free space27pgexamine
https://www.depesz.com/2026/03/17/waiting-for-postgresql-19-add-non-text-output-formats-to-pg_dumpall/
Waiting for PostgreSQL 19 – Add non-text output formats to pg_dumpall – select * from depesz;
postgresql 19add nonoutput formatswaitingtext
https://www.postgresql.org/support/security/CVE-2025-8714/
PostgreSQL: CVE-2025-8714: PostgreSQL pg_dump lets superuser of origin server execute arbitrary...
postgresql cve 2025pg dumporigin server8714lets
https://www.postgresql.org/docs/17/app-pgwalsummary.html
PostgreSQL: Documentation: 17: pg_walsummary
pg_walsummary pg_walsummary — print contents of WAL summary files Synopsis pg_walsummary [option...] [file...] Description pg_walsummary is used to print the …
postgresql documentation 17pg
https://pgsupport.dk/postgresql-failover-clustering/
PostgreSQL Failover Clustering - PG Support
postgresqlfailoverclusteringpgsupport
https://www.postgresql.org/support/security/CVE-2025-8715/
PostgreSQL: CVE-2025-8715: PostgreSQL pg_dump newline in object name executes arbitrary code in...
postgresql cve 2025pg dumpobject nameexecutes arbitrary8715
https://www.depesz.com/2026/03/22/waiting-for-postgresql-19-add-pg_plan_advice-contrib-module/
Waiting for PostgreSQL 19 – Add pg_plan_advice contrib module. – select * from depesz;
postgresql 19waitingaddpgplan
https://www.pgedge.com/blog/semantic-caching-in-postgresql-a-hands-on-guide-to-pg_semantic_cache
Semantic Caching in PostgreSQL: A Hands-On Guide to pg_semantic_cache
If you're running an AI-powered application like a chatbot, a RAG pipeline, an analytics assistant, or others, you've likely added a cache to cut down on...
semantic cachingpostgresqlhandsguidepg
https://www.postgresql.org/docs/17/app-pgcombinebackup.html
PostgreSQL: Documentation: 17: pg_combinebackup
pg_combinebackup pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups Synopsis pg_combinebackup [option...]...
postgresql documentation 17pg
https://pgscorecard.com/
PG Scorecard - PostgreSQL Compatibility Index
PG Scorecard helps you assess the compatibility of databases with PostgreSQL, ensuring seamless migrations and feature support analysis.
postgresql compatibilitypgscorecardindex
https://git.postgresql.org/gitweb/?p=pg_adviser.git;a=shortlog
git.postgresql.org Git - pg_adviser.git/shortlog
git postgresqlpgadvisershortlog
https://www.postgresql.org/docs/current/pgstatstatements.html
PostgreSQL: Documentation: 18: F.32. pg_stat_statements — track statistics of SQL planning and...
F.32. pg_stat_statements — track statistics of SQL planning and execution # F.32.1. The pg_stat_statements View F.32.2. The pg_stat_statements_info View...
postgresql documentation 18pg stat statementsf32track
https://www.meetup.com/armenia-postgresql-user-group/
Armenia PostgreSQL User Group (PG Armenia) | Meetup
🐘 Armenia PostgreSQL User Group brings together developers and enthusiasts from all backgrounds and skill levels to learn about PostgreSQL: the #1 open source...
postgresql user grouparmeniapgmeetup
https://www.vuxml.org/freebsd/48e6d514-5568-11ef-af48-6cc21735f730.html
VuXML: PostgreSQL -- Prevent unauthorized code execution during pg_dump
vuxml postgresqlprevent unauthorizedcode executionpg dump
https://postgresql.life/tags/pg_plan_advsr/
pg_plan_advsr | PostgreSQL Person of the Week
Interviews with PostgreSQL Persons of the Week
postgresql personpgplanweek
https://christian-rossow.de/articles/PostgreSQL_pg-randomness_And_Expected_Random_Byte_Entropy.php
c-r.de: Report - pg_randomness v1.1 released: PostgreSQL and Expected Random Byte Entropy for bytea
c r dev1 1reportpgrandomness
https://www.postgresql.org/support/security/CVE-2026-2007/
PostgreSQL: CVE-2026-2007: PostgreSQL pg_trgm heap buffer overflow writes pattern onto server memory
postgresql cve 2026heap buffer overflowserver memory2007pg
https://git.postgresql.org/gitweb/?p=pg_bsd_indent.git;a=shortlog
git.postgresql.org Git - pg_bsd_indent.git/shortlog
git postgresqlpgbsdindentshortlog
https://www.postgresql.org/docs/current/pgupgrade.html
PostgreSQL: Documentation: 18: pg_upgrade
pg_upgrade pg_upgrade — upgrade a PostgreSQL server instance Synopsis pg_upgrade -b oldbindir [-B newbindir] -d oldconfigdir -D newconfigdir [option...]...
postgresql documentation 18pg
https://www.postgresql.org/docs/devel/catalog-pg-authid.html
PostgreSQL: Documentation: devel: 52.8. pg_authid
52.8. pg_authid # The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of “users” and …
postgresql documentation52 8develpgauthid
https://www.postgresql.org/support/security/CVE-2024-7348/
PostgreSQL: CVE-2024-7348: PostgreSQL relation replacement during pg_dump executes arbitrary SQL
postgresql cvepg dumpexecutes arbitrary20247348