What’s new in PG15
PostgreSQL releases major versions relatively often, about once a year. This is because the PostgreSQL Global Development Group (PGDG) is committed to providing new features and improvements to the database on a regular basis. Of...
Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive
As the AI revolution surges forward, promising significant innovations, it also introduced new types of vector databases. A vector database stores data as high-dimensional vectors called embeddings, which are mathematical representations of features or attributes...
ClusterControl adds in-place major PostgreSQL upgrade and pgvector extension in latest release
We’re thrilled to announce that ClusterControl (CC) version 1.9.8 is now available! This latest release brings a range of exciting features to ClusterControl users, including an in-place major version upgrade for PostgreSQL, the addition of...
Introduction to the Severalnines ClusterControl API and SDK – Part I
This is Part I of a multi-part Several9s blog series on how to use Severalnines' ClusterControl REST API client SDK to programmatically control ClusterControl in order to accomplish many facets of database life cycle management...
Best New Features in PostgreSQL 14
According to StackOverflow, PostgreSQL is the most popular open-source database, with more and more developers and administrators wanting to work with it. PostgreSQL 14, the latest version released in September 2021, has more than 200...
How to Deploy Teamcity with PostgreSQL for High Availability
TeamCity is a continuous integration and continuous delivery server built in Java. It's available as a cloud service and on-premises. As you can imagine, continuous integration and delivery tools are crucial to software development, and their availability...
Upgrading PostgreSQL 11 to PostgreSQL 13 with TimescaleDB and PostGIS in Linux using pg_upgrade
Businesses and enterprises using old versions of PostgreSQL (PG) face challenges when upgrading to at least the most recent stable version from PostgreSQL 12 or PostgreSQL 13. There are many reasons why upgrading to the...
PostgreSQL and TimescaleDB backup restoration using ClusterControl CLI
Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. Backups are the basic way to keep it...
ClusterControl: Intro to the New Query Monitor
ClusterControl 1.9.0 was released on July 16th 2021 with a lot of new features introduced to the system. Those features include Redis Management and Monitoring, a new agent-based Query Monitoring system for MySQL and PostgreSQL,...
Proactive PostgreSQL Monitoring (Developer Studio/Advisors angle)
Monitoring is a way to know if your systems are working properly. Even when using a robust technology like PostgreSQL, it is important to have a good monitoring system that allows you to prevent issues...
ClusterControl – Advanced Backup Management – PostgreSQL
Information is one of the most valuable assets in a company, so you will need a good Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or hardware failure. Backups...
Upgrading to PostgreSQL13
In a recent blog about what is new in PostgreSQL 13, we reviewed some of the new features of this version, but now, let’s see how to upgrade to be able to take advantage of...