Page contents

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

dashboard
Jan 31, 2023

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).

postgres
Jan 30, 2023

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.

docs
Jan 26, 2023

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.

feature
Jan 10, 2023

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

cli
Nov 18, 2022

Bridge CLI v3.1.0 release

The bridge CLI tool (cb) v3.1.0 has been released.

See official release for more information.

dashboard
Nov 16, 2022

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.

feature
Nov 16, 2022

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.

feature
Nov 9, 2022

Additional region support

Clusters can now be provisioned in AWS EU-West-2 (London) and GCP Asia-Southeast1 (Singapore) regions.

cli
Oct 18, 2022

Bridge CLI v3.0.0 release

The bridge CLI tool (cb) v3.0.0 has been released.

See official release for more information.

feature
Oct 13, 2022

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
Oct 13, 2022

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.

feature
Sep 26, 2022

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.

dashboard
Sep 22, 2022

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.

dashboard
Sep 7, 2022

Added Hasura connection instructions

Get connection instructions for Hasura Cloud in your cluster.

You will find the instructions under the Connection tab.

dashboard
Aug 30, 2022

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.

dashboard
Aug 30, 2022

Database Insights

Get insight data on your database directly in your dashboard.

Cache Hit Ratio, Index Hit Ratio, Read %, and more.

cli
Aug 22, 2022

Bridge CLI v2.2.1 release

The bridge CLI tool (cb) v2.2.1 has been released.

See official release for more information.

dashboard
Aug 21, 2022

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.

cli
Aug 19, 2022

Bridge CLI v2.2.0 release

The bridge CLI tool (cb) v2.2.0 has been released.

See official release for more information.

docs
Aug 17, 2022

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!

feature
Aug 2, 2022

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.

feature
Aug 1, 2022

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.

feature
Jul 22, 2022

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.

feature
Jul 8, 2022

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
Jun 28, 2022

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
Jun 24, 2022

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.

api
Jun 24, 2022

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.

feature
Jun 22, 2022

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
Jun 16, 2022

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
Jun 8, 2022

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.

feature
Jun 8, 2022

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.

cli
Jun 3, 2022

Bridge CLI v2.1.0 release

The bridge CLI tool (cb) v2.1.0 has been released.

See official release for more information.

api
Jun 1, 2022

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.

feature
May 25, 2022

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.

api
May 24, 2022

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.

api
May 24, 2022

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.

postgres
May 19, 2022

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.

feature
May 19, 2022

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.

feature
May 19, 2022

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.

feature
May 19, 2022

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.

api
May 19, 2022

Add list cluster backups

Added an API endpoint to support listing the current backups for a cluster.

cli
May 17, 2022

Bridge CLI v2.0.0 release

The bridge CLI tool (cb) v2.0.0 has been released.

See official release for more information.

postgres
May 12, 2022

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.

cli
May 9, 2022

Bridge CLI v1.3.0 release

The bridge CLI tool (cb) v1.3.0 has been released.

See official release for more information.

dashboard
May 1, 2022

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.

cli
Apr 8, 2022

Bridge CLI v1.2.0 release

The bridge cli tool (cb) v1.2.0 has been released.

See official release for more information.

feature
Mar 30, 2022

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.

dashboard
Mar 24, 2022

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.

feature
Mar 10, 2022

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.

dashboard
Mar 7, 2022

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.

api
Mar 4, 2022

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.

api
Mar 1, 2022

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.

dashboard
Feb 14, 2022

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.

feature
Feb 14, 2022

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
Feb 12, 2022

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.

dashboard
Feb 11, 2022

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.

dashboard
Feb 11, 2022

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.

api
Feb 4, 2022

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.

api
Feb 3, 2022

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.

dashboard
Jan 31, 2022

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.

docs
Jan 31, 2022

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.

docs
Jan 26, 2022

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
Jan 26, 2022

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.

dashboard
Jan 25, 2022

Restart instance

The Crunchy Bridge Dashboard now supports the ability to restart your Postgres instance. Restart is available within the settings for the cluster.

feature
Jan 25, 2022

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
Jan 25, 2022

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.

api
Jan 25, 2022

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.

dashboard
Jan 21, 2022

Dark mode

The Crunchy Bridge Dashboard now supports dark mode. It can be activated by visiting your account settings.

2021

api
Dec 30, 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.

api
Dec 23, 2021

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.

api
Dec 24, 2021

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.

dashboard
Dec 16, 2021

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.

dashboard
Dec 16, 2021

Support replica resizing

Added support for replicas to be resized from the Dashboard, available within the replica detail view of the cluster overview.

dashboard
Dec 16, 2021

Error page enhancements

The Crunchy Bridge Dashboard now has a new error page for 404s that provides more helpful cross links and resources.

postgres
Nov 11, 2021

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.

feature
Oct 19, 2021

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.

feature
Aug 10, 2021

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.