Posts about Production Postgres
PostgreSQL Node Metrics: Don't Fly Blind
Monitor your PostgreSQL container node and get host metrics with the Postgres extension pgnodemx.
13 min read
Introducing the Postgres Prometheus Adapter
To make it easier for anyone that wants to use Postgres as their backing store for Prometheus, we’re proud to announce the release of the PostgreSQL Prometheus Adapter.
5 min read
Why PostgreSQL 13 is a Lucky Release
See why PostgreSQL 13 is a lucky release as it adds features like incremental sort, parallel vacuum, and improves performance of B-tree indexes and more!
8 min read
Preventing SQL Injection Attacks in Postgres
Learn about SQL injection attacks and how to prevent them in Postgres.
8 min read
Announcing pgBackRest for Azure - Fast, Reliable Postgres Backups
Backups are a key staple of running any database. pgBackRest aims to be a fast, reliable, easy-to-use backup and restore solution with the ability to seamlessly scale to the largest databases.
3 min read
Setup ora2pg for Oracle to Postgres Migration
An important part of performing a migration from Oracle to PostgreSQL is selecting the right tool for helping with the conversion between systems.
9 min read
How to Recover When PostgreSQL is Missing a WAL File
Creation and clean up of WAL files in the primary's pg_wal folder (pg_xlog prior to PG10) is a normal part of PostgreSQL operation. The WAL files on the primary are used to ensure data consistency during crash recovery. Use of write-ahead logs (also called redo logs or transaction logs in other products) is common for data stores that must provide durability and consistency of data when writing to storage. The same technique is used in modern journaling and log-structured filesystems.
14 min read
Control Runaway Postgres Queries With Statement Timeout
A well tuned production Postgres database is capable of easily running thousands or up to hundreds of thousands of queries per second on a beefy instance.
4 min read
Optimize PostgreSQL Server Performance Through Configuration
Learn the top 5 settings to tune once an install of PostgreSQL is completed to optimize performance.
5 min read
Guard Against Transaction Loss with PostgreSQL Synchronous Replication
Learn how to deploy PostgreSQL on Kubernetes with synchronous replication to guard against losing transactions.
17 min read
Migrating from Oracle to PostgreSQL: Tips and Tricks
Migrating from one database to another is inherently new technology and can raise a multitude of questions.
9 min read
How To Simplify pgBouncer Monitoring with pgbouncer_fdw
In order to more easily monitor PgBouncer, the team at Crunchy Data developed an open source PgBouncer Foreign Data Wrapper (pgbouncer_fdw).
5 min read
How to Perform a Major Version Upgrade Using pg_upgrade in PostgreSQL
Tested methods for upgrading PostgreSQL software from one major release to another with the least amount of headache.
4 min read
Hope Is Not A Strategy: How Hardware Issues Affect Your PostgreSQL Data
Learn how the HPE SSD issues can impact your PostgreSQL data, and what strategies you can take to protect your data.
3 min read
How To Get Started with pgBackRest and PostgreSQL 12
With the recent release of PostgreSQL 12, pgBackRest also received a number of updates and changes to take advantage of the latest features of Postgres.
10 min read
PostgreSQL Change Data Capture With Debezium
A step-by-step guide for how to setup PostgreSQL change data capture with Debezium and Apache Kafka
10 min read
Just Upgrade: How PostgreSQL 12 Can Improve Your Performance
Just upgrade and take advantage of performance improvements in PostgreSQL 12.
8 min read
How To Correct and Identify Indexes Affected by the GNU C 2.28 Update
Version 2.28 (release notes) of the GNU C library introduces many changes to the collations it provides. Collations determine how strings are compared and by default, PostgreSQL uses the operating system’s collations which on Linux means glibC. When your operating system updates to this version of glibc and you aren't using the “C” or “POSIX” collation, you may encounter some differently ordered indexes. This unexpected change in the order of indexes will lead to incorrectly ordered query results and possible data corruption. Currently, the following distributions are affected:
3 min read
PostgreSQL Zero to Hero: Getting Started with RPMs -Part 1
One of the most important things to using PostgreSQL successfully in your development and production environments is simply getting started! One of the most popular ways to install PostgreSQL is by using RPM packages. This guide demonstrates how you can get PostgreSQL up and running with RPMs!
5 min read
How to setup Windows Active Directory with PostgreSQL GSSAPI Kerberos Authentication
PostgreSQL provides a many authentications methods to allow you to pick the one that makes the most sense for your environment. This guide will show you how to use your Windows Active Directory to authenticate to PostgreSQL via GSSAPI Kerberos authentication.
5 min read
