EDB Knowledge Base

• 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
• PostgreSQL gaps in sequences
• Where are my PostgreSQL logs?

See all 106 articles

• Postgres memory recommendations, Linux overcommit and OOMs
• Logical replication setup from standby on EPAS
• Deadlock detected messages in BDR or PGD
• Handling Replication Slots With EFM
• walsender timeout errors in BDR/pglogical/logical replication
• WAL Archiving Best practices

See all 50 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

• 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
• Simulate replication slots with Barman and PostgreSQL 9.3
• Recipe - Hot logical backup of all databases
• PITR with Barman

See all 21 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

• 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
• Release Announcement EDB Postgres Distributed 5.4.1

See all 401 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