Manage databases by using HoloWeb-Hologres(Hologres)-阿里云帮助中心

Prerequisites

You have connected to an instance. For more information, see connect to an instance.

Create a database

Log on to the Hologres management console.
In the top navigation bar, select a region.
Click Go to HoloWeb to open the HoloWeb developer page.
On the HoloWeb development page, click Metadata Management > Database.

You can also right-click a target connection in the Instance Connected list on the Metadata Management page and select Create Database. In the Instance Management panel on the left, right-click a connected instance and select Create Database from the context menu.

Configure the Database Name, Permission Model, and Log On parameters, and then click OK. The available options for permission policy are SPM, SLPM, or the standard PostgreSQL authorization model. If you set Log on to Yes, all open tabs for the current database will close upon login. Make sure to save your work.

Parameter	Description
instance name	Displays the name of the connected instance by default.
database name	Enter a name for the database. Note The database name must be unique within the instance.
permission policy	Select a permission policy for the database based on your business requirements. For more information about permission policies, see the following topics: SPM SLPM standard PostgreSQL authorization model
Log on	Yes: You are automatically logged on to the database and can use it immediately. No: You must manually log on to the database before you can use it.

Log on to a database

From the Metadata Management page, you can log on to a database in one of the following ways:

When you create the database, set the Log On parameter to Yes. You are automatically logged on to the database and can use it immediately.
If you set the Log On parameter to No during creation, you must log on manually. In the Instance Connected list, right-click the target database that is not logged on and select Log On to Database.

Note
The icon is black when you are logged on to a database and grayed out when you are not.

Edit a database

In the Instance Connected list on the Metadata Management page, find the target database.
Right-click the target database and select Edit Database.
Update the Permission Model as needed.

Note
Currently, the Edit Database feature only allows you to modify the Permission Model.

Delete a database

In the Instance Connected list on the Metadata Management page, find the target database.
Right-click the target database and select Delete Database.
In the confirmation dialog box, click OK.

References

You can also use SQL statements to create, alter, and delete databases. For more information, see the following topics: