--- title: Blog posts tagged "PostgreSQL" description: Canonical makes open source secure, reliable and easy to use, providing support for Ubuntu and a portfolio of enterprise-grade technologies. Founded in 2004, Canonical operates globally with team members in over 80 countries. url: https://canonical.com/blog/tag/postgresql?format=md --- # Blog posts tagged "PostgreSQL" #### [Charmed PostgreSQL enters General Availability](https://canonical.com/blog/charmed-postgresql) An enterprise-grade PostgreSQL you can rely on Jul 17, 2024: Today Canonical announced the release of Charmed PostgreSQL, an enterprise solution that helps you secure and automate the deployment, maintenance and upgrades of your PostgreSQL databases across private and public clouds. PostgreSQL is an open source database management system. --- Company #### [How to secure your database](https://canonical.com/blog/secure-database) Cybersecurity threats are increasing in volume, complexity and impact. Yet, organisations struggle to counter these growing threats. Cyber attacks often intend to steal, damage, hijack or alter value-generating data. In this article around database security, we use the NIST framework to lay out the common controls that you can implement t --- Data Platform #### [PostgreSQL high availability made charmingly easy](https://canonical.com/blog/postgresql-high-availability) In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our open source recipe for PostgreSQL high availability. Benefits of a highly available PostgreSQL  A good recipe should always start by exposing the benefits of the concerned meal. Therefore, we will start this --- Data Platform #### [Should you use open-source databases?](https://canonical.com/blog/open-source-databases) You are not the only one asking this seemingly popular question! Several companies are torn between the rise in appeal of open-source databases and the undeniable challenges inherent to their adoption. Let’s explore the trends, the drivers and the challenges related to open-source database adoption. The popularity of open-source databases --- Charms #### [Patterns to achieve database High Availability](https://canonical.com/blog/database-high-availability) The cost of database downtime A study from ManageForce estimated the cost of a database outage to be an average of $474,000 per hour. Long database outages are the result of poor design concerning high availability. With the exponential growth of data that is generated over the internet (which is expected to reach 180 zeta-bytes --- Cloud and server #### [How to cache snap downloads and save bandwidth](https://canonical.com/blog/how-to-cache-snap-downloads-and-save-bandwidth) For many people, fast broadband connection and unlimited data are a reality. For others, they are not. If you have several Linux hosts in your (home) environment, and you’re using snaps, each of these systems will separately communicate with the Snap Store and periodically download necessary updates. This can be costly in terms of inbound --- Cloud and server #### [Let’s play: sharded big data PostgreSQL](https://canonical.com/blog/lets-play-sharded-big-data-postgresql) Everyone knows that if you’ve got big data, you need Apache Hadoop, right? It’s an affordable, horizontally scalable, clustered data processing platform ideal for data warehousing use cases. And it knocks the socks off classic relational database management systems like PostgreSQL that can barely keep up when playing with a terabyte of da --- Data Systems #### [What is PostgreSQL and why do banking software developers love it?](https://canonical.com/blog/what-is-postgresql) PostgreSQL is a powerful, open source object-relational database system that is known for reliability, feature robustness, and performance. PostgreSQL is becoming the preferred database for more and more enterprises. It is currently ranked #4 in popularity amongst hundreds of databases worldwide according to the DB-Engines Ranking. The ba --- Financial Services #### [PostgreSQL: The PgMiner botnet attacks & Postgres database security](https://canonical.com/blog/postgresql-security-the-pgminer-botnet-attacks-explained) Assuring the security of PostgreSQL and all open source database systems is critical as many learned with the PgMiner botnet attacks in December 2020. Having an understanding of, and visibility into, how these attacks happen and following standard best practices is the best way to make sure that your data is not at risk. This --- Company #### [Create your Linux development workstation in seconds](https://canonical.com/blog/create-your-linux-development-workstation-in-seconds) Linux is the best platform for developers. Here’s how you can get popular languages and development environments up and running in moments. The first step is to install snapd (the service that runs and manages Snaps) on your distro, then you can install your pick from some of our recommendations below. We regularly share new --- Desktop #### [Think Cloud portable! Let Applications drive the Model](https://canonical.com/blog/think-cloud-portable-let-applications-drive-the-model) In our last intro to Modeling with Juju post we didn’t pay any attention to the hardware needed to run our workloads. We ran with Juju default values for what the hardware characteristics of the cloud instances should be. Rather than define a bunch of YAML about each machine needed to run the infrastructure, Juju picks sane defaults that --- Cloud and server