Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Joseph Mckulka
Joseph Mckulka
Crunchy Postgres for Kubernetes can be used for cross-datacenter streaming replication out of the box. With so many folks asking for cross-cloud / cross-datacenter replication, we wanted to give people a large explanation of how that works. For this post, we use streaming replication, and prioritize reducing latency and adding stability. Cross-cloud streaming replication can be used: • To enable multi-cloud disaster recovery • For moving clusters between cloud providers • For moving clusters be...
Read MoreElizabeth Christensen
Elizabeth Christensen
Multi-PgBouncer is our affectionate in-house name for a special use case of running multiple instances of PgBouncer. PgBouncer is the venerable go-to tool for managing connection pooling at the database layer for Postgres. For some of our customers with notably large databases and high throughput, running multi-PgBouncer has been a great way to keep up with load and connections. David Christensen recently did a talk at PGConf.NYC entitled “ How to Tame a Mastodon: Lessons for PostgreSQL at Sca...
Read MoreCraig Kerstiens
Craig Kerstiens
I wanted to take a little time today to walk through some of the security and team controls you get out of the box on Crunchy Bridge . Within teams for Crunchy Bridge you have the ability to: • Restrict authentication for a team to SSO • Event logs of all actions for a team • Audit logs of queries run against your database Restrict authentication for a team to SSO Event logs of all actions for a team Audit logs of queries run against your database We'll take a look at each of these in dee...
Read MorePaul Ramsey
Paul Ramsey
Last week Craig Kerstiens published a great introduction to Postgres terminology , covering some of the basics you might run into when just getting started. The funny thing about jargon is how quickly we get used to it, and forget we are even using it. It becomes part of the secret handshake, the way we signal to other members of our tribe that we're part of the group. When I first started going to Postgres conferences and listening to talks by Postgres core developers I suddenly found myself...
Read MoreBrandur Leach
Brandur Leach
When we started building Crunchy Bridge two years ago, we chose Ruby as the language to write our database state machine and control plane API. Ruby may not have been the most popular language choice in 2022, but we picked it anyway. A major reason is that everyone on the team already knew it well and liked it. Terse and elegant syntax is perfect for expressing our database state machine logic. Another reason we picked Ruby is that it lets us have a REPL running in production so we can carry o...
Read MoreElizabeth Christensen
Elizabeth Christensen
So you’re new to Postgres and you want to test it out and see how it works. Or maybe you’re building a new app and you need to seed your database. How do you get data in your Postgres database? There’s a lot out there on the topic of data migration for Postgres and some of it can be complicated and overwhelming. I’m going to give you some quick and simple ways to get test data IN your database. If you need to load data from csv files, the psql command in Postgres is a utility that can come...
Read MoreCraig Kerstiens
Craig Kerstiens
In my career I've worked on teams that ran and managed over a million databases, and I've helped shard and scale database for customers at 100s of terabytes. Postgres is an incredibly flexible database , and because of it's flexibility you have a lot of options for architecting your data design for your application needs. In talking with current customers and future customers how you design and architect your database is a common topic. We're going to dig into some of the flexibility on archi...
Read MoreAndrew L'Ecuyer
Andrew L'Ecuyer
Lukas Fittl recently posted one of his 5 minutes of Postgres videos about his experimentation with different Kubernetes Postgres Operators: Postgres on Kubernetes, choosing the right operator, and handling major version upgrades . One passage about version updates caught my interest: The other article I found interesting was this post by Andrew from the Crunchy Data team , where he describes how the PGO operator now makes it easy to do major version upgrades. This is actually pretty cool. I th...
Read MorePaul Ramsey
Paul Ramsey
In a recent post , we introduced pg_eventserv and the real-time web notifications from database actions. In this post, we will dive into a practical use case: displaying state, calculating events, and tracking historical location for a set of moving objects . This demonstration uses pg_eventserv for eventing, and pg_featureserv for external web API, and OpenLayers as the map API, to build a small example application that shows off the common features of moving objects systems. Try it...
Read MoreCraig Kerstiens
Craig Kerstiens
We love Postgres and want it to be available to as many as possible. This is why we released our playground for people to come and learn Postgres. This is why we write about using Postgres and why we published our Postgres tips . Today, we launch two updates to make Postgres even more available to developers. 1. Hobby tier plans now begin at $10 a month. This the same full-featured Postgres all our customers get. No packed multi-tenant setups. 2. When you spend under 5 in billing — there is...
Read More