EDB Knowledge Base

• Checking WAL size generated for a particular query
• Broken postgres checkpoint rare occurrence
• Securing EPAS TDE Encryption Keys using Azure Key Vault
• Monitoring streaming replication in PostgreSQL
• SQL Datatype mismatch preventing index use (with JDBC example)
• CTE materialization default behavior changed in PostgreSQL 12

See all 108 articles

• PgPool PCP commands
• PgPool and EFM integration for application high availability
• PgPool ADM extension
• PgPool Watchdog and VIP basic configuration
• PgPool basic configuration for streaming replication
• PgPool SHOW commands

See all 57 articles

• xDB SMR CLI setup
• xDB MMR setup using CLI
• Major Version DB Upgrade using EPRS

• Setting up and managing PostgreSQL operator with MinIO on Kubernetes
• Basic installation of Kubernetes on RHEL
• Deploying and verifying a new trial license key in Kubernetes
• Transparent Data Encryption (TDE) in EDB Postgres Extended (PGE) in a Kubernetes Environment
• Openshift - Set Up htpasswd as the Identity Provider and Add Users and Permissions
• Kubernetes local testing with Kind

See all 8 articles

• Incremental Backups in PostgreSQL 17
• How to configure non super user for PgBackRest
• Barman Full Backup from Standby and WAL Streaming from Primary
• Actions needed on Barman after performing a PostgreSQL major upgrade
• Why we recommend to install Barman on a separate server
• Speed up getting WAL files from Barman with barman-wal-restore

See all 24 articles

• Running Lasso to send diagnostic information
• How to change the backup storage location in PEM
• Monitoring Barman with PEM
• Quickstart with LiveCompare in a BDR cluster
• Periodic Lasso reports for Insights from a Linux server
• Job Scheduler and pgagent error investigation

See all 13 articles

• How to convert non-TDE nodes to TDE in a PGD cluster using TPAexec
• How to use TPAexec to create a local repository for air-gapped environments
• How to deploy a cluster with TPAexec using satellite repositories
• How to solve the error in TPAexec where Ansible is not set
• Running tests with TPAexec

• Executing database queries using EDB JDBC
• Terminate hung postgres backends waiting for oracledblinks
• Using passwordless authentication with postgres_fdw (e.g. client certificates)
• Performance recommendations for foreign tables
• How to return IN OUT and OUT parameters from executing procedures on a remote Oracle database
• How to handle ties in LiveCompare

See all 9 articles

• Re-Release of November 2024 Maintenance Releases
• CVE-2024-7348 Time-of-check Time-of-use (TOCTOU) race condition in pg_dump
• Release Announcement EDB Postgres AI Q2 Release
• Patch release for EDB Postgres Extended (PGE) Server & EPAS
• End Of Platform Support Announcement (Debian 10, RHEL/Centos 7)
• Release Announcement EDB LassoⓇ 4.15.0

See all 402 articles

• Using artifactory with EDB repositories
• How to reset the EDB Support Portal password
• Analyzing memory usage of processes using /proc
• What data should you share when opening a ticket
• How to get the GPG key of a repository
• Override or Customize SystemD Environment Settings

See all 21 articles