Hologres:Databases

Create a database

1. Log on to the Hologres management console.

2. In the top navigation bar, select a region.

3. Click Go to HoloWeb to open the HoloWeb developer page.

4. On the HoloWeb development page, click Metadata Management > Database.

   Alternatively, in the Metadata Management interface, right-click the target connection in the Logged-on Instances list, and select Create Database.

5. Configure the Database Name, Permission Model, and Log On parameters, then click OK.

   Parameter	Description
   Instance Name	The name of the logged-on instance where the current database resides is displayed by default.
   Database Name	Name the current database. Note The configured database name must be unique.
   Access Policy	Configure permissions for the database as needed. For more information about access policies, see: SPM SLPM standard PostgreSQL authorization model
   Log on Immediately	Yes: Use the created database directly after logging on. No: Log on to the database before using it.

Log on to a database

Edit a database

1. On the HoloWeb development page, the Logged-on Instances list in the Metadata Management interface displays all logged-on instance names.

2. Right-click the target database, and select Edit Database.

3. Modify the value of the Permission Model parameter as needed.

   Note

   Currently, Edit Database only supports modifying the Permission Model configuration item.

Delete a database

1. On the HoloWeb development page, the Logged-on Instances list in the Metadata Management interface displays all logged-on instance names.

2. Right-click the target database, and select Delete Database.

3. After confirming the database content, click OK.

References

You can also create, modify, and delete databases using SQL statements. For more information, see:

• CREATE DATABASE

• ALTER DATABASE

• DROP DATABASE