Hologres:Databases

Prerequisites

Before you begin, ensure that you have:

• Logged on to an instance. For details, see Log on to an instance

Create a database

1. Log on to the Hologres Management Console.

2. In the navigation pane on the left of the top menu bar, select your region.

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

4. 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 parameters, then click OK.

   Parameter	Description
   Instance name	The name of the logged-on instance. Displayed by default.
   Database name	A unique name for the database.
   Access policy	The permission model for the database. Choose one of the following: SPM, SLPM, or standard PostgreSQL authorization model.
   Log on immediately	Yes: Use the created database directly after logging on. No: Log on to the database manually before using it.

   

Log on to a database

In the Metadata Management interface, log on to a database using one of the following methods:

• At creation time: Set Log on immediately to Yes. The database is logged on by default.

• After creation: Right-click the target database in the Logged-on Instances list, and select Log On to Database.

  

When the database is logged on, the icon appears in bright black. When it is not logged on, the icon is grayed out.

Edit a database

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

1. In the Metadata Management interface, locate the target instance in the Logged-on Instances list.

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

3. Modify the Permission Model as needed.

Delete a database

1. In the Metadata Management interface, locate the target instance in the Logged-on Instances list.

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

3. Confirm the database content, then click OK.

What's next

To manage databases using SQL statements instead of HoloWeb, see:

• CREATE DATABASE

• ALTER DATABASE

• DROP DATABASE