Latest posts
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
pgBackRest - Performing Backups on a Standby Cluster
Disaster recovery and backup tools like pgBackRest help ensure the high-availability of PostgreSQL, but there are cases where you do not want run them on your primary, such as due to I/O constraints or archiving a replica in another data center. This guide shows how to run pgBackRest with a replica.
14 min read
PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage
A PostgreSQL block range index, or BRIN, can help you to significantly reduce the amount of disk space required for high performance queries on big data.
14 min read
Upgrading PostGIS on Centos 7
How do you handle PostGIS and PostgreSQL updates? This guide provides step-by-step instructions for safely upgrading your PostGIS installations to the latest versions using the packages provided by the community.
6 min read
WITH Queries: Present & Future
WITH queries, aka common table expressions, aka CTEs, are a very powerful but often misused feature in PostgreSQL. The upcoming PostgreSQL 12 introduces the ability to inline WITH queries with can provide a huge performance optimization to how developers use CTEs.
13 min read
PostgreSQL Deep Dive: How Your Data Model Affects Storage
Your PostgreSQL data model directly affects how much data is stored on disk. Additionally, your ingest rate and retention could affect whether you require 10TB or 100TB of storage! This deep dive can help you save orders of magnitude of disk space before using sharding or other distributed models.
16 min read
Managing Transaction ID Exhaustion (Wraparound) in PostgreSQL
Learn how to prevent transaction ID wraparound in PostgreSQL through some simple monitoring and prevent TXID wraparound from ever becoming a problem!
9 min read
A Guide to Building an Active-Active PostgreSQL Cluster
A guide to building an active-active PostgreSQL cluster to help meet high-availability requirements of keeping your PostgreSQL database always up and available
14 min read
What's New in Crunchy PostgreSQL Operator 3.5
The latest release of the Crunchy PostgreSQL Operator brings significant improvements to the high-availability and disaster recovery features needed to run PostgreSQL in large-scale, production enterprise environments.
4 min read
Scheduling Backups En Masse with the Postgres Operator
A solid disaster recovery plan for your PostgreSQL clusters combined with pgBackRest and the Crunchy PostgreSQL Operator will help you manage your backups across thousands of PostgreSQL instances with only a few commands.
5 min read
Get Started Running PostgreSQL on Kubernetes
Learn how to run PostgreSQL natively on Kubernetes based platforms so you can manage your own database-as-a-service.
3 min read
Performing a Major PostgreSQL Upgrade with pg_dumpall
For most major upgrades using a utility such as pg_upgrade or a replication tool such as pglogical will be the best solution. However if these options are not available, pg_dumpall can be used to safely perform a major upgrade of your PostgreSQL database.
2 min read
Won’t You Be My Neighbor? Quickly Finding Who is Nearby
Many location aware applications need to find things are people that are close to a specific location. The KNN-GiST functionality of PostgreSQL helps developers to create high performance queries to quickly find neighbors, with applications in mapping and proximity searches.
7 min read
Why Covering Indexes in Postgres Are Incredibly Helpful
Covering indexes in PostgreSQL are an incredibly helpful feature that can help improve the performance of your application when used correctly. This article demonstrates how an application that collects time-series and geospatial data is able to use covering indexes to boost performance.
11 min read
Using the CIS PostgreSQL Benchmark to Enhance Your Security
This CIS PostgreSQL Benchmark, co-authored by Crunchy Data and the Center for Internet Security, is a detailed guide with best practices and recommendations for securing your PostgreSQL clusters. This guide teaches you how to use the CIS PostgreSQL Benchmark to secure your database.
5 min read
Using Kubernetes Deployments for Running PostgreSQL
The Crunchy PostgreSQL Operator helps to automate many typical database administration tasks at scale and leverages Kubernetes Deployments to flexibility in building environments that feature high-availability, configurable resource management, and seamless upgrades.
5 min read
Troubleshooting PostgreSQL Streaming Replication Synchronization
A practical guide to detecting if your PostgreSQL replicas are out-of-sync and how to restore them efficiently without a base backup.
9 min read
Upgrading PostgreSQL from 9.4 to 10.3 with pglogical
Here is a case study for how to efficiently upgrade major versions of PostgreSQL with almost zero-downtime using pglogical
6 min read
How to Perform Failover with the PostgreSQL Kubernetes Operator
The Crunchy PostgreSQL for Kubernetes Operator makes it easy to maintain a high-availability database cluster by making failover from a primary to a replica database as simple as one command.
4 min read
Fast CSV and JSON Ingestion in PostgreSQL with COPY
COPY is also incredibly helpful for ingesting data such as JSON or CSV into a PostgreSQL table, especially if there is a lot of it. Learn how to use COPY to optimize your data loading performance in PostgreSQL.
7 min read
