Crunchy Data joins Snowflake. Read the announcement
Elizabeth Christensen
Elizabeth Christensen
Crunchy Data hosted the third annual PostGIS Day on November 18th.This was our second year with a virtual format and another year of record attendance! We had attendees from more than 99 countries. PostGIS is the most popular geospatial database in the world, with: • over 300 vector and raster functions • high performance analytical and transactional functionality • easy integration with all third-party mapping and data processing tools over 300 vector and raster functions high perform...
Read MoreJonathan S. Katz
Jonathan S. Katz
One of the many reasons " the answer is Postgres " is due to its extensibility. The ability to extend Postgres has given rise to an ecosystem of Postgres extensions that change the behavior of the database to support a wide range of interesting capabilities. At Crunchy Data we are big fans of PostGIS , the geospatial extender for Postgres. Another extension we are asked about often is TimescaleDB . TimescaleDB is an open-source extension designed to make SQL scalable for time-series data....
Read MoreJonathan S. Katz
Jonathan S. Katz
Did you know that PostgreSQL 12 introduced a way for you to provide multifactor (aka "two-factor") authentication to your database? This comes from the ability to set as part of your pg_hba.conf file, which manages how clients can authenticate to PostgreSQL. When you specify , PostgreSQL requires a connecting client to provide a certificate that is valid against its certificate authority ( CA ) and the certificate's common name ( CN ) matches the username the client is authenticating...
Read MoreJonathan S. Katz
Jonathan S. Katz
I recently wrote an example of how you can project monthly recurring revenue ( MRR ) in Postgres . This is a helpful metric to understand how a subscription-based business is doing and can help inform all sorts of financial and operational decisions at the company. Since writing that example, my same friend running their SaaS business on Crunchy Bridge wanted to find out how much revenue they were accruing per day over the course of a month. When a new month started, the accrued revenue wou...
Read MoreJonathan S. Katz
Jonathan S. Katz
You've built an application and are using Postgres to run it. You move it into production. Things are going great. So great that you've accumulated so much data that you need to resize your disk. Before the cloud, this often involved either expanding your disk partitioning or getting a new disk, both of which are costly operations. Cloud has made this much easier: disk resizes can occur online or transparently to the application, and can be done as simply as clicking a button (such as in Crunch...
Read MoreCaitlin Strong
Caitlin Strong
Crunchy Data products often include High Availability. Patroni and etcd are two of our go-to tools for managing those environments. Today I wanted to explore how these work together. Patroni relies on proper operation of the etcd cluster to decide what to do with PostgreSQL. When communication between these two pieces breaks down, it creates instability in the environment resulting in failover, cluster restart, and even the the loss of a primary database. To fully understand the importance of...
Read MoreCraig Kerstiens
Craig Kerstiens
Whether you are starting a new development project, launching an application modernization effort, or engaging in digital transformation, chances are you are evaluating Kubernetes. If you selected Kubernetes, chances are you will ultimately need a database . While many have success with Kubernetes-native database deployments, others prefer the benefits of a managed database. When it comes to databases, at Crunchy Data we believe the answer is more often than not Postgres, and the question is h...
Read MoreDouglas Hunley
Douglas Hunley
Crunchy Data is proud to announce an update to the CIS PostgreSQL Benchmark by the Center for Internet Security ( CIS ). CIS is a nonprofit organization that publishes best practices and standards for securing modern technology and systems. This newly published CIS PostgreSQL 14 Benchmark ads to the existing CIS Benchmarks for PostgreSQL 9.5 - 13 and builds upon Crunchy Data's ongoing efforts with the PostgreSQL Security Technical Implementation Guide (PostgreSQL STIG ). A CIS Benchmark is...
Read MoreJonathan S. Katz
Jonathan S. Katz
As more data workloads shift to running on Kubernetes , one of the important topics to consider is security of your data. Kubernetes brings many conveniences for securing workloads with the ability to extend security functionality databases through the use of the Operator pattern . Database security best practices on Kubernetes is a frequent conversation we're having with our customers around deploying PostgreSQL on Kubernetes with PGO , the open source Postgres Operator from Crunchy Dat...
Read MoreJonathan S. Katz
Jonathan S. Katz
Encrypting data at rest is often an important compliance task when working on securing your database system . While there are a lot of elements that go into securing a PostgreSQL database , encrypting data at rest helps to protect your data from various offline attacks including the stealing of a disk or tampering. Disk encryption is a popular feature among public database-as-a-service providers, including Crunchy Bridge, to protect data in a multi-tenant environment. There is ongoing work i...
Read More