In this blog post, we'll discuss how to set up streaming replication in Windows. Credit goes to my colleague Douglas Hunley whose blog post on setting up streaming replication on Linux served as inspiration.
We're putting together an awesome PostGIS Day virtual conference on Thursday, Nov 19th. Last year we hosted our first PostGIS Day in-person in St. Louis and although we can't gather in the same way this year, going virtual allows us to give even more talks!
Apple's Intel-based laptops are very popular among developers, and that's as true of people who work on PostgreSQL as other groups. Tomorrow, the first shipping Apple laptops running on ARM CPUs instead of Intel are expected.
I was sent a link to a tweet regarding election night forecasting and of course the default questions was... could be run under PL/R inside Postgres. Like about everything else at Crunchy Data we believe all things are better with Postgres.
In this post I'll walk through the steps to connect a Django app to PostgreSQL in the cloud via Crunchy Bridge.
In the last post of this series we introduced trying to model fire probability in Northern California based on weather data. We showed how to use SQL to do data shaping and preparation.
In our previous blog post, we talked about upgrading a PostgreSQL cluster to a new major version with pg_upgrade. But in some instances zero downtime may be essential.
As a database grows and scales up from a proof of concept to a full-fledged production instance, there are always a variety of growing pains that database administrators and systems administrators will run into.
When should you be alerted about issues in your PostgreSQL clusters? How do you troubleshoot them? What are some typical solutions?
What are some PostgreSQL monitoring stats that are typically used to monitor the health of your databases?
What are some of the key stats to look at to ensure your PostgreSQL cluster is healthy? How can you use this stats to diagnose the problem?
Set up turnkey monitoring for PostgreSQL clusters running on Kubernetes using the Postgres Operator!
PostgreSQL has supported streaming replication and hot standbys since version 9.0 (2010), and synchronous replication since version 9.1 (2011).
PostgreSQL 13 was released last week. I'm excited about this one, as the more mature partitioning plus logical replication features allow some long-requested deployment architectures
PG Routing is a powerful routing tool, usually used for pathfinding/mapping/direction applications. Today we’re going to use Postgres via Crunchy Bridge to find the most influential Yacht Rock artist, and find out why it’s Michael McDonald.
Kat explores a few interesting things she encountered in PL/Python data type mapping, especially when adding NumPy and SciPy to the picture.
In this post, we'll try running NumPy in a simple user-defined function which also takes advantage of PL/Python database access functions. The function will show a working example of how to easily convert a data table in Postgres to a NumPy array.
Crunchy Bridge delivers on the premise of a managed database service allowing you to focus on your application not your database, but we go several steps further.
Which hidden gem features in Postgres 13 can have a big impact?
Today's post is going to work through the advice I received on using joins rather than subqueries.