Need a GUI for your Postgres cluster? PGO 5.1 introduces a new feature to let you create a pgAdmin 4 pod alongside your other database services managed by the Kubernetes Operator.
Have too much static data? Paul has a idea of moving some of it to a datalake. He provides a walk-through of setting up Parquet with Postgres using the parquet_fdw.
Today we’re excited to introduce support for major PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessly upgrade your clusters across major versions of PostgreSQL.
We're excited to announce the general availability of version 5.1 of PGO, the open source Postgres Operator from Crunchy Data. In addition to providing a seamless upgrade experience across both PGO and PostgreSQL versions, this feature-packed release also introduces many powerful new capabilities.
Load some PostGIS data, import a shape file and publish a map to the web. Easy peasy lemon squeezy.
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
In this post we'll show some examples of spatial filtering using CQL with pg_featureserv.
Paul takes a recent example of GPU-assisted spatial joins project to see how PostGIS stacks up in the same situation. He goes through the steps of joining a large record set of parking data with neighborhood data.
Recently Crunchy Data added pg_featureserv support for most of CQL2. Here we'll describe the powerful new capability it provides.
Fun with PostgreSQL! Using the French Wordle list, this post shows you some sql to find out the most often used letters in a table, how to reduce possibilities once you’ve found some letters, and how to solve wordle puzzles using the back end.
New feature release for PGO v5.0.5 Initializing your Postgres database with backups from AWS S3, GCS or Azure.
Risk management for Postgres. A guide to changing application user permissions so they can't delete your production database.
Examples of Postgres constraints using a schema and data requirements for a reservation system.
A guide on securing the pgBackRest user for high-security Postgres environments.
Paul walks through spatial indexes and queries to find a solution to a recent postgis-user query.
Samples of b-tree, GIN, and GIST indexes for Postgres beginners.
You're an Oracle DBA and now you have to support a Postgres database! Where do you start? Stephen has a review of some of the high points in getting started with PostgreSQL.
How to create a Kubernetes cluster from scratch, including getting it to run with cgroup v2 and swap turned on.
A guide to setting up streaming replication between two separate Postgres clusters using the Postgres Operator for Kubernetes.