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…
I have another short video to share with you. This video demonstrates some of the new enhancements made to the user experience of Data Services Manager (DSM) 2.2. The video focuses mainly on certificate management and authentication, specifically HBA or host based authentication. I show how you can add a custom certificate chain and private key when provisioning a database via DSM 2.2. I also show you how to add additional entries to the pg_hba.conf file via the UI at deployment time so that you can add or deny database access to certain users from certain networks. I also show…
This is the second in a series of videos related to Data Services Manager (DSM) version 2.2 from VMware by Broadcom. In this video, we examine how to configure replication between a primary and a secondary Postgres database. Whilst the video shows the replication being configured between a primary and secondary database managed by the same DSM provider, replication could also be configured between a primary and secondary database managed by different DSM providers. Thus, the primary database could reside on infrastructure managed by one vCenter server, and replicate to a secondary database on infrastructure managed by a completely different…
Last week, we announced a new version of Data Services Manager (DSM), version 2.2. One of the key features added to this release is the ability to provision Postgres databases across multiple vSphere clusters, allowing for much higher levels of database availability than ever before. This video will show you how to create an infrastructure policy that enables this cross vSphere cluster topology, as well as how to consume this policy when provisioning a Postgres database from within the DSM portal/UI. The result of this is that DSM will place the primary node, replica node and Monitor of the Postgres…
It gives me great pleasure to announced that the latest version of Data Services Manger (DSM) is now available. Version 2.2 has a wealth of new features related to the deployment, management and monitoring of data services on VMware Cloud Foundation (VCF). I will share these features in greater detail in this post, but please also refer to the official DSM 2.2 documentation for further information. Let’s get started. Multi-Cluster Deployments for increased availability In previous versions of DSM, databases and data services could be provisioned in two modes. The first is standalone mode which deploys the data service as…
I recently has a question about retrieving the Certificate Authority (CA) from a PostgreSQL database which has been provisioned by Data Services Manager (DSM). The customer in question wanted his clients to use the verify-ca option on database connections for additional security. To allow secure connections with verify-ca, the CA needs to be downloaded from the database to the device where the client is making the connection from. In this post, we will go through how to get the certificate so that the Verify-CA option is used to make client connections to a PostgreSQL database secure. Note that this is…