PGNexus Daily News

PostgreSQL Technical Articles

High Availability for EDB Postgres Advanced Server Using EFM and PgPool: A Complete Setup Guide

enterprisedb.com

High Availability for EDB Postgres Advanced Server Using EFM and PgPool: A Complete Setup Guide

This guide describes a two-layer high availability architecture for EDB Postgres Advanced Server (EPAS) using EDB Failover Manager (EFM) and PgPool-II. EFM monitors the primary-st…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Proposal: new file format for hba/ident/hosts configuration?

The thread discusses a proposal to introduce a new file format for PostgreSQL's hba/ident/hosts configuration files. Zsolt Parragi shares JSON5 versions of previous TOML mockups a…

Read Discussion
Missing FSM Update when Updating VM On-access

The discussion addresses a bug where the Free Space Map (FSM) is not updated when the Visibility Map (VM) is set on-access during heap page pruning, potentially causing VACUUM to…

Read Discussion
REASSIGN OWNED vs. relisshared dep on !relisshared

Recent commits added fields `pg_subscription.subserver` and `pg_subscription.subconflictlogrelid`, each creating a dependency link from the shared catalog `pg_subscription` to a n…

Read Discussion
Show expression of virtual columns in error messages

A patch to display virtual column expressions in PostgreSQL error messages is under development. Matheus Alcantara has submitted v6, rebased against master due to changes introduc…

Read Discussion
s/pg_attribute_always_inline/pg_always_inline/?

The discussion focuses on renaming the macro `pg_attribute_always_inline` to `pg_always_inline` in PostgreSQL's codebase and how to handle backpatching. The agreed approach is to…

Read Discussion
implement CAST(expr AS type FORMAT 'template')

The discussion concerns implementing SQL standard T839: `CAST(expr AS type FORMAT 'template')`. Haibo Yan previously proposed a generic format-cast mechanism covering datetime, nu…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Apple Sues OpenAI Over Alleged Trade Secret Theft

techcrunch.com

Apple Sues OpenAI Over Alleged Trade Secret Theft

Apple has filed a lawsuit against OpenAI, alleging trade secret theft directed by OpenAI's senior leadership, including a long-time former Apple employee. The lawsuit marks a sign…

techcrunch.com

OpenAI GPT-5.6 Named Preferred Model for Microsoft Copilot 365

OpenAI has announced that its GPT-5.6 model is the preferred choice to power Microsoft's Copilot 365 suite of workplace and productivity applications. The announcement comes amid…

Social Media Updates

linkedin

CYBERTEC CEO Hans-Juergen Schoenig on why open source gives you something proprietary vendors can't: a chance.

CYBERTEC CEO Hans-Juergen Schoenig argues that open source software offers users something proprietary vendors fundamentally cannot: a genuine opportunity. Speaking in the context…

linkedin

Genie One is the data-smart AI coworker that helps business users move from insight to action.

Genie One is an AI assistant designed to help business users act on data insights. Its Genie Agents feature allows teams to convert prompts into shareable, autonomous agents capab…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more