Changelog
The following are recent changes in the Crunchy Bridge product. Each is marked as to whether it applies to a core Postgres feature, a UI change in the Crunchy dashboard, an update to our docs, an update to the Crunchy CLI (command line interface), or a change to the platform’s REST API.
Current
Personal team certificate available in Dashboard
Every Crunchy Bridge account has a Personal team by default.
The root certificate for this personal team can now be downloaded via the dashboard. This certificate can be used locally to secure and verify connections to your personal team cluster(s).
hypopg and pg_ivm extensions now available
Two new extensions are now availble for your Postgres cluster.
The hypopg extension allows for the creation of hypothetical indexes. These can be useful for testing indexes without actually creating them.
The pg_ivm extension allows for incremental updating of materialized views. With this approach, incremental changes are computed and applied, rather than the entirety of the contents.
Remove schedule maintenance endpoint
An unfinished endpoint for scheduling a cluster maintenance was accidentally leaked in to the docs. We've removed this endpoint documentation. User's should instead use POST /clusters/:id/upgrade endpoint utilizing the starting_from parameter to explicitly schedule a cluster maintenance for a specific time.
Create replicas of replicas
The API now allows creating replicas of replicas.
This feature can be useful to ensure that before detaching an existing read replica that it has it's own replicas in place and available to handle traffic.
2022
Bridge CLI v3.1.0 release
The bridge CLI tool (cb) v3.1.0 has been released.
See official release for more information.
Rotate passwords from DB roles from Dashboard
The roles table now has an option to rotate the password for each role. This will work for default roles like postgres as well as all user roles.
Tailscale Support
It is now possible to connect a cluster to your Tailscale network. Connections can be configured in your cluster on the Networking tab.
Additional region support
Clusters can now be provisioned in AWS EU-West-2 (London) and GCP Asia-Southeast1 (Singapore) regions.
Bridge CLI v3.0.0 release
The bridge CLI tool (cb) v3.0.0 has been released.
See official release for more information.
New Graviton-based hobby-0 and hobby-1 instances available on AWS
New smaller plans hobby-0 and hobby-1 are available to provision on AWS, coming with 512 MB and 1 GB of memory respectively. These are based on EC2's T4g instances, which are powered by ARM-based Graviton 2 processors.
hobby-0 is available at a base price point of $9 ($10 with a 10 GB disk), the lowest ever for a Bridge plan.
Postgres 15 is now available
Postgres 15 is now available. The new major features improved sorting performance, the MERGE command, and adds more capabilities for observing the state of the database. See the release notes for more details.
Google Marketplace now available
Crunchy Bridge can now be provisioned directly through Google Marketplace to take advantage of its consolidated billing. See Crunchy Bridge on Google Marketplace.
Added Vacuum Stats and Table Size Insights
We have added two more cluster insight views: - Vacuum statistics - Table sizes
You can find these insights in your cluster under the Insights tab.
Added Hasura connection instructions
Get connection instructions for Hasura Cloud in your cluster.
You will find the instructions under the Connection tab.
Application specific connection instructions
We have added application specific instructions for connecting to you cluster. We launched with support for: - Prisma (Javascript) - Rails (Ruby) - Laravel (PHP) - Phoenix (Elixir) - Spring (Java) - Django (Python)
You can find these in a new Connection tab on existing clusters.
Database Insights
Get insight data on your database directly in your dashboard.
Cache Hit Ratio, Index Hit Ratio, Read %, and more.
Bridge CLI v2.2.1 release
The bridge CLI tool (cb) v2.2.1 has been released.
See official release for more information.
See active roles on a cluster
Crunchy Bridge users may use the Cluster > Roles page to see which users have a role on the primary cluster and read replicas.
Bridge CLI v2.2.0 release
The bridge CLI tool (cb) v2.2.0 has been released.
See official release for more information.
Postgres Playground Launched
Learn Postgres interactively in your browser with a series of helpful tutorials from the basics of querying in psql to more advanced lessons on optimizing performance. Check out the Postgres Playground today!
Invoice emails contain PDF attachments
Invoice emails that go out on the first day of the month now contain a PDF rendering of the invoice as an attachment. Aside from being more convenient to reference (and forward) without logging in, we expect this to be helpful for archival purposes.
Terraform provider now available
Crunchy Bridge users who use Hashicorp's Terraform tool for provisioning infrastructure can now include Crunchy Bridge clusters among their managed resources by using the newly released crunchybridge provider.
The initial release includes support for creating, deleting, scaling up, and other cluster updates. The connection string to managed clusters can easily be configured as parameters to other Terraform modules.
Visit the documentation for the Crunchy Bridge provider to get started.
Protected clusters
Clusters can now be set to "protected" by managers and admins, which makes them undestroyable unless protection is removed first. Protection can be enabled from a cluster's overview page by selecting "Cluster Actions" → "Enable Protection".
It can also be enabled from the API by setting is_protected on the update cluster endpoint.
Create and access physical backups on AWS and Azure
Clusters running on AWS and Azure can now have a physical backup started via the API or Dashboard. Once complete, the physical backup files can be accessed directly.
API key authentication
As a developer convenience, API keys can now be used as a Bearer token in the Authentication header to authenticate with the API key directly, rather than having to produce an access tokens first. We still recommend the use of shorter-lived access tokens to reduce the chances of exposure for security-critical programs.
See getting started with the API for more information.
Postgres 14 is now default, again
Now that Postgres 14.4 which addresses a major bug in Postgres' INDEX and REINDEX CONCURRENTLY commands has been available for some time and showing good results, Postgres 14 is once again the default version provisioned with new Bridge clusters.
Signed access tokens
Access tokens are now ephemeral signed objects rather than records persisted to the database. Procuring and authenticating with them stays identical to before.
A side effect of signing is that access tokens are now longer. For best results, continue treating an access token's secret as an opaque string that may be of variable length.
Since procuring an access token is now cheaper in terms of database load, we've removed the rate limit on creating them.
Azure Marketplace integration now available
Crunchy Bridge can now be provisioned directly through your Azure Marketplace account if you would like to consolidate billing.
The availability of Crunchy Bridge on Azure Marketplace now provides users with a fully managed Postgres service from the Postgres experts at Crunchy Data.
Postgres 14.4 is now available
Postgres 14.4 is now available, and the default for Postgres 14 provisions.
We recommend upgrading immediately as 14.4 contains a fix for the upstream bug in Postgres' INDEX and REINDEX CONCURRENTLY.
Postgres 13 is temporarily default
We've temporarily changed our default version of Postgres back to 13 while an upstream bug in Postgres' INDEX and REINDEX CONCURRENTLY is being investigated. Users can still create Postgres 14 clusters, but should make sure not to use concurrent index creation or rebuilding.
The Bridge upgrade system provides an easy way to upgrade between major Postgres versions, so you can also create a Postgres 13 cluster today and migrate it to 14 after a bug fix is released.
Postgres 13 is temporarily default
We've temporarily changed our default version of Postgres back to 13 while an upstream bug in Postgres' INDEX and REINDEX CONCURRENTLY is being investigated. Users can still create Postgres 14 clusters, but should make sure not to use concurrent index creation or rebuilding.
The Bridge upgrade system provides an easy way to upgrade between major Postgres versions, so you can also create a Postgres 13 cluster today and migrate it to 14 after a bug fix is released.
Bridge CLI v2.1.0 release
The bridge CLI tool (cb) v2.1.0 has been released.
See official release for more information.
Suspend and resume GCP clusters from the API
The API endpoints that support suspending a cluster and resuming a cluster now support GCP.
Suspended clusters have no active virtual machine (and are therefore unreachable), but their disks are kept so that they can be later unsuspended.
These actions are also available in cb v2.1.0.
Create forks from backups
When viewing the backup list you will be able to create a new fork from any of your backups using the "Fork From Backup" button on that row.
Suspend and resume clusters from the API
New API endpoints are available for suspending a cluster and resuming a cluster. A cluster's current suspended status is available via the is_suspended property on the cluster resource.
Suspended clusters have no active virtual machine (and are therefore unreachable), but their disks are kept so that they can be later unsuspended.
Currently, suspend/resume is only available on AWS and Azure.
These actions are also available in cb v2.1.0.
List and start backups from the API
New API endpoints are available for listing cluster backups and manually starting a cluster backup.
These actions are also available in cb v2.1.0.
h3 extension now available
The h3 extension which adds h3 bindings to Postgres is now available. New instances can enable it with CREATE EXTENSION. Pre-existing instances require a failover to begin using it.
orafce extension now available
The orafce extension which adds provides Oracle compatability functions is now available. New instances can enable it with CREATE EXTENSION. Pre-existing instances require a failover to begin using it.
h3 extension now available
The h3 extension which adds h3 bindings to Postgres is now available. New instances can enable it with CREATE EXTENSION. Pre-existing instances require a failover to begin using it.
Backup listing now available
You can now view the times of your backups and backup history. To shorten fork recovery time you can provision your forks closer to a backup completion to minimize WAL replay.
Add list cluster backups
Added an API endpoint to support listing the current backups for a cluster.
Bridge CLI v2.0.0 release
The bridge CLI tool (cb) v2.0.0 has been released.
See official release for more information.
Postgres 14.3 and Postgres 13.7 is now available
Postgres 14.4 and Postgres 13.7 is now available.
For full release notes on fixes included please review the PostgreSQL release notes.
Bridge CLI v1.3.0 release
The bridge CLI tool (cb) v1.3.0 has been released.
See official release for more information.
Add invoice notes
It is now possible to add a top level note that when set will automatically be applied to all future team invoices.
This top level note is editable from the team invoices page. It is also possible to edit the individual invoice note directly on each invoice.
Bridge CLI v1.2.0 release
The bridge cli tool (cb) v1.2.0 has been released.
See official release for more information.
Container Apps
Container Apps allow you to launch and run a container from directly within Postgres. This feature is currently in public beta.
See container apps for more information.
Add SSL Certificate download for team
Team admins may now download the public certificate used by the Postgres server for encrypting connections with SSL from the settings pages in the Bridge Admin.
Red Hat OpenShift Database Access (RHODA) inaugural partner
Red Hat's OpenShift Database Access (RHODA) includes Crunchy Bridge among its initial integration partners to provide streamlined access to 3rd party data services.
The Kubernetes Operator for Crunchy Bridge provides the access for RHODA and may support other future Kubernetes to Crunchy Bridge integrations.
For more information on RHODA, see how it simplifies managed database access on OpenShift.
Enforce team single sign-on (SSO)
Team admins may now enforce SSO on teams. Find the setting in Team › Settings in Bridge. Admins must be signed in through SSO to activate the enforce SSO feature.
team_member.roles removed
The API has removed the deprecated roles field from team_member. Use of role field is now the only supported method for interacting with a team members role on a team.
team_member.* events generated
The API now generates team_member.* events whenever an account is added, removed, or had its role updated on a team. These are also visible under a team's Audit Log in Dashboard.
Select replicas for support tickets
Users may now select a replica to report when creating a ticket on the Crunchy Bridge Support page. This cuts down on extra message cycles with customers to point our support team to an issue with a replica.
Automatic resizes and low disk notifications
Disks on clusters that reach 90% utilization will be resized automatically to prevent potential operational problems. Disks under 1 TB will increase in size by 25% and disks over 1 TB will increase in size by 10%.
A notice will be sent to a cluster's team's administrators when an automatic resize occurs, and also as a cluster gets closer to being fully – at 75%, 80%, and 85%.
See automatic disk resizes for more information.
Postgres 14.2 and Postgres 13.6 is now available
Postgres 14.4 and Postgres 13.7 is now available.
For full release notes on fixes included please review the PostgreSQL release notes.
Edit team member roles
Team roles can now be changed directly in the Dashboard without the need to remove/add an account to adjust their role.
New database roles
Postgres superuser role, application role, and individual roles are now displayed in the Dashboard. For more detail on the specific roles see the docs for roles API endpoints. Members see only their individual role, while admins and managers see all roles.
Team member get API endpoint
Added an API endpoint to retrieve a specific team member given a team and account ID. See get team member.
Cluster roles API
Added an API to create and manage cluster roles (see cluster roles), including an idempotent endpoint that allows account-specific roles to be easily created.
A new application role also becomes available by default, meant to be useful so that there's an easily-accessible non-superuser role for use in apps connecting to a Bridge cluster.
Detach replicas in Dashboard
Replicas associated with a cluster may now be detached from a cluster in the Replicas section in its Cluster Overview page. Once detached, the replica now behaves as a main cluster and no longer receives updates from the parent. It may take up to a minute before a detached replica is fully ready. After detaching, it may be helpful to rename the cluster in its Settings page to make it more easily distinguishable as a separate cluster.
Generated API reference
The API reference documentation is now generated automatically, making it much more complete, much more accurate, and adding new features like field-specific documentation and request/response examples. Its design has also been iterated, making it more legible, and adding extra visual features like syntax highlighting.
The reference is generated from an OpenAPI specification which is itself generated from the API's own source code, and a periodic job regenerates it from the latest deployed version, so it's no longer easily possible for the reference to drift out of date.
Product changelog
We've added a changelog that highlights new features in the core database product, Dashboard, API, CLI, and documentation. Like Postgres' WAL, the changelog will endeavor to be a durable and robust system for keeping up-to-date with changes as they happen.
Docs redesign
We've redesigned our documentation subsite for better legibility and to make navigation easier. Check it out at docs.crunchybridge.com. We'll continue to iterate on the redesign over the coming months to provide more useful information and refine what's already there.
Restart instance
The Crunchy Bridge Dashboard now supports the ability to restart your Postgres instance. Restart is available within the settings for the cluster.
Postgres 14 is now default
With Postgres 14.1 now released and Postgres 14 having been GA since late September, we've made it the default major version for newly created clusters.
Postgres 14 is now default
With Postgres 14.1 now released and Postgres 14 having been GA since late September, we've made it the default major version for newly created clusters.
Default Postgres major version
The API endpoint to create a cluster at POST /clusters will now default to a Postgres major version instead of requiring one to be specified. Currently this default is Postgres 13, but will change over time as new Postgres versions are released and become sufficiently stable.
Dark mode
The Crunchy Bridge Dashboard now supports dark mode. It can be activated by visiting your account settings.
2021
Replica detach endpoint
Added new API endpoint PUT /clusters/:id/detach which stops replication to a replica, causing the replica become a new primary. Detach is not synchronous, but will take place soon after the API endpoint is invoked.
Server restart endpoint
Added new API endpoint PUT /clusters/:id/restart which restarts a cluster's underlying server. Restart is not synchronous, but will take place soon after the API endpoint is invoked.
Changelog API
Adds new API endpoints GET /changelogs and GET /changelogs/:id which list and get API and feature changes within the Crunchy Bridge product.
Cross platform replica provisioning
Added support for replicas to be provisioned cross platform in Dashboard console. For example, it's now possible to provision a replica in Azure for a primary located in AWS.
Support replica resizing
Added support for replicas to be resized from the Dashboard, available within the replica detail view of the cluster overview.
Error page enhancements
The Crunchy Bridge Dashboard now has a new error page for 404s that provides more helpful cross links and resources.
Postgres 14.1 and Postgres 13.5 is now available
Postgres 14.1 and Postgres 13.5 is now available.
For full release notes on fixes included please review the PostgreSQL release notes.
AWS Marketplace integration now available
Crunchy Bridge can now be provisioned directly through your Amazon Web Services (AWS) account if you would like to consolidate billing.
After subscribing through AWS Marketplace, you'll be able to log in and create database clusters in the AWS region of your choice, with a wide range of available instance sizes, and options for high availability and read replicas.
Heroku Addon (Beta) now available
Heroku users can now provision and integrate Crunchy Bridge managed PostgreSQL databaes from within Heroku.
See the Crunchy Bridge Addon page for more details.