To manage a database, you can either use an existing instance or add a new instance.
Before You Begin
Configure the permissions to access the Azure resources. Download the CvPostgreSQLRole.json file and use it to apply the permissions.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
Click Add instance, and then select Cloud DB.
The Add Cloud DB instance dialog box appears.
-
From the Select vendor list, select a vendor where you want to create an instance.
-
From the Database service list, select PostgreSQL.
-
From the Cloud account list, select a hypervisor.
If you do not have a hypervisor to select, you can add a hypervisor. For more information, see Adding a Hypervisor.
-
From the Backup plan list, select a server plan.
-
From the Instance name list, select an instance.
-
In the Database user box, type the user name to access the Azure Database for PostgreSQL application.
-
In the Password box, type the password to access the Azure Database for PostgreSQL application.
-
In the Maintenance DB box, type the name of the system database that is used as the maintenance database.
-
Click Add.
Tip
Enter the user name in the syntax username@hostname.
Results
-
The new instance contains a dump-based backup set and a default subclient.
-
When you add an instance, a default database group is automatically created. The default database group includes all the data in the PostgreSQL database. You cannot delete the default database group.