Your submission was sent successfully! Close

Thank you for signing up for our newsletter!
In these regular emails you will find the latest updates from Canonical and upcoming events where you can meet our team.Close

Thank you for contacting our team. We will be in touch shortly.Close

PostgreSQL operations, simplified

Secure and automate the deployment, maintenance and upgrades of your PostgreSQL databases across private and public clouds.


Contact us

Made to give you
peace of mind

  • SLA-backed support with optional screen sharing
  • 10 years of security maintenance
  • Hybrid and multi-cloud ready

Run PostgreSQL on your favourite stack and across clouds



A hyper-automated PostgreSQL made for high availability

Thanks to our software operator for PostgreSQL, your deployments will be:

  • Highly available with built-in replication and automatic failover.
  • Reliable with expert-crafted and self healing state-machine automation.
  • Upgraded automatically during your maintenance windows and with minimum downtime.
  • Disaster recovery ready with built-in backup and restore capabilities to ensure business continuity.
  • Hybrid and multi-cloud ready — Our automation supports deployment within and across private and public clouds.
  • Shipped with a holistic observability and alerting solution based on Prometheus, Loki and Grafana and Loki to monitor all of your database fleets.

What can you achieve with PostgreSQL?

PostgreSQL is one of the most popular databases. Its popularity is rooted in its sound architectural foundations that make it a good fit for several use cases:


Web and mobile applications

PostgreSQL is a solid choice for e-commerce and content sharing platforms.


Data warehousing and Business Intelligence applications

PostgreSQL is famous for its excellent support of the SQL standard. It also supports a large panel of index types and can nicely integrate with other data stores (using foreign wrappers) making it an excellent choice for running analytical queries without the need to duplicate your data.


Applications managing geospatial data

The PostGis extension of PostgreSQL is an excellent choice to support use cases managing spatial data.


FinOps and banking

PostgreSQL provides the transactional ACID guarantees and the mature replication capabilities that finance systems need. The pgAudit extension can also complement PostgreSQL with the auditing capabilities that regulated industries require.


Text search use cases

PostgreSQL offers a variety of index structures (e.g. GIN and GIST) to perform advanced full text search operations on your data without the need for duplicating it or compromising on its consistency.


Hardened and supported software packages

We provide 10 years maintenance for our PostgreSQL related artefacts in the format of your choice:

You can also get 24/7 support with optional screen sharing for all your PostgreSQL deployments.

Purchase your subscription

How it works

The diagram below depicts a high level overview on the components we use:

Key architecture insights:

  • We use Patroni to manage the high availability of PostgreSQL.
  • We use PgBouncer to provide connection pooling and transparent failovers for the connected applications.
  • We expose two endpoints. One for read and write operations on the primary, and another one to scale reads on the replicas.
  • We can backup our deployments to any S3 compatible storage solution.
  • We provide a full monitoring and alerting solution based on Prometheus, Loki and Grafana.
Set up your PostgreSQL database

Services

Managed PostgreSQL

We manage your PostgreSQL deployments in the cloud of your choice. We can build a private cloud, adapt to your existing one or use public cloud infrastructure.

We take care of automatically deploying, hardening, patching, optimising and upgrading your PostgreSQL databases using our open source operators.


Consulting

Unlock the potential of your data with Canonical's advisory services. We can:

  • Design and architect tailored solutions for your specific use cases.
  • Deliver Proof of Concepts (PoC) to implement your ideas and de-risk your projects.
  • Train your staff on Canonical's solutions for PostgreSQL.


PostgreSQL related resources

Our guides

Database cloud migration

Best practices to migrate your data to the cloud.


Data backup

Improve your security posture with a backup strategy.


From our blog

PostgreSQL high availability made charmingly easy

Set up Charmed PostgreSQL by following a set of commands.


Patterns to achieve database high availability

Avoid downtime with these proven best practices.


Should you use open source databases?

Learn about the drivers and challenges in open source database adoption.


“PostgreSQL” is a trademark or registered trademark of PGCA. Other trademarks are property of their respective owners. Canonical's PostgreSQL offerings are not sponsored, endorsed, or affiliated with PGCA.