My good pal Duncan Epping invited me onto his Unexplored Territory podcast last week to talk about all things related to Data Services Manager (DSM) version 2.2. We had a good chat about most of the new features that you can expect to find in the latest DSM release. As always, it is pleasure to chat with Duncan on his podcast, so I hope you find it informative and entertaining. Click on the link below to listen.
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…
Ever have one of those moments when you realised “Oh shoot! I didn’t mean to delete that!”. Now imagine if that thing was a production database. Ouch! But not to worry. With Data Services Manager version 2.2 we have you covered. This release has a new feature called Database Delete Protection. Now if you delete a database, we will keep its backups archived for 30 days by default. This means you can restore the deleted database for up to 30 days after the database was deleted. This is a much sought-after feature that many of our customer has requested. Check…
I have another new video to share with you today. This looks at another new feature of Data Services Manager version 2.2. This feature is the ability to scale down the virtual machine resources associated with a Postgres database VM. The ability to scale up the virtual machines resources has been available for some time, but this is the first time we have had scale down capabilities. As you will see in the video, it is done by choosing a different VM Class for the database. VM Classes are defined in the Infrastructure Policy. So now if you expect a…
I have been doing some work with OpenLDAP in my lab, with a goal to give OpenLDAP users access to a PostgreSQL databases that I have been deploying via Data Services Manager v2.2. There are a few steps involved in achieving this. First, of course, is that I have to configure Directory Services on DSM, and point it at my OpenLDAP server. Second step is to provision a Postgres database which has Directory Service Authentication enabled. The third and final step is to give my OpenLDAP user permissions to login and access the database. In this blog post, each of…