Many of our customers have security policies in place which require all passwords to be rotated on a regular basis. Many of our customers are also looking at ways to automate this process, and avoid having to login via the DSM UI and update all of their database passwords manually. As you can imagine, doing this manually can be a very tedious task. Fortunately, there is way to automate this process via the DSM API for Postgres databases. In this post, I will demonstrate the steps involved to allow you to automate the changing of DSM provisioned database admin passwords…
One feature that many of our customers have asked about is the ability to ingest existing Postgres databases into Data Services Manager (DSM). As part of DSM 2.2, our team has put together a step by step guide into how to achieve this using the logical replication feature available in Postgres. The guide is included here as part of the official DSM 2.2 documentation. I decided to build a stand-alone Postgres database and follow the instructions to get the database into Data Services Manager. I built a Postgres v15.10 database on a VM running Debian 12 (bookworm). I picked up…
DSM has had the ability to do minor version upgrades of databases for some time. In fact, minor version upgrades can be automated in DSM by simply setting a maintenance window on the database. Any minor updates that are available and staged will be automatically applied during the maintenance window. And of course, this could be scheduled out-of-hours. With version 2.2, we can now offer our customers ‘major version upgrades’ for Postgres databases alongside minor version upgrades. The following video will share more details about the process, and some of the things to be aware of it doing a major…
A short video on the new DSM 2.2 Object Store service to complement my earlier blog post on the new Data Service Manager 2.2 Object Store service. This service is delivered in partnership with MinIO. This will allow our customers to provision and monitor object stores on vSphere infrastructure. Note that this is a “tech preview” and should not yet be used in production. However, we encourage customers to try and it out and send us their feedback as part of a “proof of concept” or PoC. Also note that customers will need to source a license from MinIO to…
I have created a new video showing how to create an PostgreSQL database in Data Services Manager (DSM) version 2.0. The objective is to show how simple it is to not only deploy a database, but also how the provisioning steps allows different vSphere infrastructure resources to be selected during the provisioning stage. This is achieved through Infrastructure Policies which we learnt about in the previous video. The demo also touches on features such as automated backups, automated lifecycle management and advanced settings, all of which may be configured at database deployment time.