PostgreSQL DBA
@postgres_tech
2.02K
subscribers
140
photos
1
video
20
files
245
links
Sharing knowledge about postgresql database
Download Telegram
Join
PostgreSQL DBA
2.02K subscribers
PostgreSQL DBA
PostgreSQL DBA
https://www.yugabyte.com/key-concepts/using-postgresql-as-a-vector-database/
Yugabyte
PostgreSQL as a Vector Database: A Complete Guide
With PostgreSQL’s extensibility (specifically the pgvector extension), a regular Postgres instance can be augmented to essentially becoming a PostgreSQL vector database.
PostgreSQL DBA
https://www.tigerdata.com/blog/building-blockchain-apps-on-postgres
Tiger Data Blog
Building Blockchain Apps on Postgres
Tips and strategies for building blockchain apps on Postgres. Read the full technical deep dive from the Tiger Data engineering team on the Tiger Data blog.
PostgreSQL DBA
https://github.com/blkchain/blkchain
GitHub
GitHub - blkchain/blkchain: Fast import of the blockchain into PostgreSQL.
Fast import of the blockchain into PostgreSQL. Contribute to blkchain/blkchain development by creating an account on GitHub.
PostgreSQL DBA
PostgreSQL DBA
https://www.postgresql.org/docs/current/protocol.html
PostgreSQL Documentation
Chapter 54. Frontend/Backend Protocol
Chapter 54. Frontend/Backend Protocol Table of Contents 54.1. Overview 54.1.1. Messaging Overview 54.1.2. Extended Query Overview 54.1.3. Formats and Format Codes 54.1.4. …
PostgreSQL DBA
https://medium.com/@sonishubham65/understanding-postgres-locks-and-managing-concurrent-transactions-1ededce53d59
Medium
Understanding Postgres Locks and Managing Concurrent Transactions
In the realm of database management systems, concurrency control is paramount to ensure data integrity and consistency, particularly in…
PostgreSQL DBA
https://www.postgresql.org/docs/current/runtime-config-locks.html
PostgreSQL Documentation
19.12. Lock Management
19.12. Lock Management # deadlock_timeout (integer) # This is the amount of time to wait on a lock before checking to …
PostgreSQL DBA
https://dev.to/alzhi_f93e67fa45b972/stream-postgresql-wals-with-zero-data-loss-in-mind-5e17
DEV Community
Stream PostgreSQL WALs with Zero Data Loss in Mind
Cloud-Native PostgreSQL WAL receiver. Stream, compress, encrypt, upload, retain and monitor your WAL...
PostgreSQL DBA
https://www.pgedge.com/blog/8-steps-to-proactively-handle-postgresql-database-disaster-recovery
Pgedge
8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery
When disaster strikes, whether a natural disaster or a technical event, its impact on your network, database, and end-users can cause both costly downtime and data corruption.
PostgreSQL DBA
https://www.postgresql.org/about/news/barman-20-released-1702/
PostgreSQL News
Barman 2.0 Released
Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. Barman …
PostgreSQL DBA
https://github.com/EnterpriseDB/barman/releases/tag/release%2F3.17.0
GitHub
Release Release 3.17.0 · EnterpriseDB/barman
Barman release notes
©
Copyright EnterpriseDB UK Limited 2026 - All rights reserved.
3.17.0 (2026-01-07)
Notable changes
Enable query, fetch, and selective operations on inactive/disabled servers...
PostgreSQL DBA
https://severalnines.com/blog/postgresql-replication-disaster-recovery/
Severalnines
PostgreSQL Replication for Disaster Recovery
This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.
PostgreSQL DBA
https://www.enterprisedb.com/optimize-postgresql-continuous-high-availability-tip-and-tools
PostgreSQL DBA
https://www.datapatroltech.com/blog/postgresql-dr-drill-with-repmgr-case-study
Datapatroltech
PostgreSQL DR Drill Case Study – See How Data Patrol Ensures Zero Downtime
Discover Data Patrol’s real-world PostgreSQL DR drill for a major pharma enterprise, featuring Repmgr-based switchover, replication checks, WAL monitoring, and HA validation. See how our process ensures seamless continuity and disaster-ready performance.
PostgreSQL DBA
https://digiqt.com/blog/postgresql-infrastructure-risk-management/
Digiqt
Reducing Infrastructure Risk with a PostgreSQL Expert Team | Digiqt Blog
Expert-led postgresql infrastructure risk management for high availability, disaster recovery, monitoring, replication, and operational stability.
PostgreSQL DBA
https://www.tigerdata.com/blog/database-backups-and-disaster-recovery-in-postgresql-your-questions-answered
Tiger Data Blog
Database Backups and Disaster Recovery in PostgreSQL
Database backups are one of the biggest pain points for developers. Use our guide to PostgreSQL backup to help you navigate your way.
PostgreSQL DBA
https://naiknotebook.medium.com/understanding-postgresql-triggers-for-real-time-database-auditing-71ed35d39906
Medium
Understanding PostgreSQL Triggers for Real-time Database Auditing
In the dynamic world of database management, ensuring data integrity and tracking changes are critical tasks, especially in production…
PostgreSQL DBA
https://infinitelambda.com/postgresql-triggers/
Infinite Lambda
PostgreSQL Triggers' Performance Impact | The Infinite Lambda Blog
We are benchmarking the impact of PostgreSQL Triggers on performance. Find the analysis and key takeaways on the Infinite Lambda blog.
PostgreSQL DBA
https://www.instaclustr.com/education/postgresql/postgresql-tuning-6-things-you-can-do-to-improve-db-performance/
Instaclustr
PostgreSQL tuning: 6 things you can do to improve DB performance
Gain an in-depth understanding of open source data layer technologies on the Instaclustr managed platform at our education Hub.
PostgreSQL DBA