Creating a Database

1. In the navigation panel, go to Databases.

2. In the top-right corner of the page, click Create database.

3. Enter parameters of the new database (parameters marked with an asterisk are required):

   • Instance: The instance where the database will be created.

   • Database name.

   • Database owner.

   • Encoding (ENCODING): The character encoding in the database.

   • Sorting category (LC_COLLATE): Specifies the LC_COLLATE value in the operating system environment of the database server.

   • Category of symbol types (LC_CTYPE): Specifies the LC_CTYPE value in the operating system environment of the database server.

   • Tablespace: The tablespace where the database will be created.

   • Allow connections: Specifies whether the database will be available for connections.

   • Limiting the number of connections: The maximum number of simultaneous database sessions.

   • Is template: Specifies whether the created database will be a template.

   • Template: The template of the database.

4. Click Save.

Viewing Databases

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

Starting the psql Terminal

The psql terminal provides low-level access to the DBMS instance and can be used when PPEM features are not sufficient. Although providing most of the standard psql functionality, it has certain limitations. For example, you cannot use the \! meta-command to run shell commands.

The DBMS instance connection parameters are used when the terminal is started.

To start the psql terminal:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click PSQL next to the database.

Collecting the Planner Statistics for a Database

The ANALYZE SQL command is executed when collecting the planner statistics.

To collect the planner statistics for a database:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click → Analyze next to the database.

4. Specify the statistics collection parameters (parameters marked with an asterisk are required):

   • Set cron-string execution: Allows specifying the time interval for collecting statistics in the crontab format.

     If you turn on this toggle, in Execution, enter the string.

   • Task planning: The type of the statistics collection task.

     Possible values:

     • Execute now: The statistics will be collected immediately after you perform this instruction.

     • Time-delayed: The statistics will be collected at the specified date and time.

     • On schedule: The statistics will be collected at the specified time interval.

       For this value, specify the following parameters:

       • Interval: The unit of measurement of the time interval.

         Possible values:

         • Minutes

         • Hours

         • Days

       • Repeat every: The time interval for collecting statistics by minutes or hours.

         This parameter is available only if you select Minutes or Hours from Interval.

       • Execution days: The days when statistics will be collected.

       • Cron total line: The string in the crontab format that specifies the time interval for collecting statistics.

         The value is entered automatically.

     This parameter is available only if you turn off Set cron-string execution.

   • Name: The unique name of the statistics collection task.

     This parameter is available only if you turn on Set cron-string execution or select Time-delayed / On schedule from Task planning.

   • Time: The date and/or time when statistics will be collected.

     This parameter is available only if you select Time-delayed from Task planning or Days from Interval.

   • Start and Repeat untill: The start and end date and time for the statistics collection.

     These parameters are available only if you turn on Set cron-string execution or select On schedule from Task planning.

5. Click Apply.

6. Confirm the operation.

Reindexing a Database

The REINDEX SQL command is executed when reindexing.

To reindex a database:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click → Reindex next to the database.

4. Specify the reindexing parameters (parameters marked with an asterisk are required):

   • Set cron-string execution: Allows specifying the time interval for reindexing in the crontab format.

     If you turn on this toggle, in Execution, enter the string.

   • Task planning: The type of the reindexing task.

     Possible values:

     • Execute now: Reindexing will be performed immediately after you perform this instruction.

     • Time-delayed: Reinxdexing will be performed at the specified date and time.

     • On schedule: Reindexing will be performed at the specified time interval.

       For this value, specify the following parameters:

       • Interval: The unit of measurement of the time interval.

         Possible values:

         • Minutes

         • Hours

         • Days

       • Repeat every: The time interval for reindexing by minutes or hours.

         This parameter is available only if you select Minutes or Hours from Interval.

       • Execution days: The days when reindexing will be performed.

       • Cron total line: The string in the crontab format that specifies the time interval for reindexing.

         The value is entered automatically.

     This parameter is available only if you turn off Set cron-string execution.

   • Name: The unique name of the reindexing task.

     This parameter is available only if you turn on Set cron-string execution or select Time-delayed / On schedule from Task planning.

   • Time: The date and/or time when reindexing will be performed.

     This parameter is available only if you select Time-delayed from Task planning or Days from Interval.

   • Start and Repeat untill: The start and end date and time for reindexing.

     These parameters are available only if you turn on Set cron-string execution or select On schedule from Task planning.

5. Confirm the operation.

Vacuuming a Database

The VACUUM SQL command is executed when vacuuming.

To vacuum a database:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click → Vacuum next to the database.

4. Specify the vacuum parameters (parameters marked with an asterisk are required):

   • Modes: The vacuum modes.

     Possible values:

     • Analyze: Updates the statistics that the planner uses for selecting the most efficient way of query execution.

     • Full: Performs a full vacuum via reindexing all table files.

       Note

       While the vacuum is being performed in this mode, all sessions working with tables that are being reindexed will be blocked.

     • Freeze: Performs an aggressive tuple freeze to expand freezing and release transaction IDs for further reuse.

       The aggressive freeze is always performed when overwriting the table, so do not select Freeze if Full is already selected.

   • Set cron-string execution: Allows specifying the time interval for vacuuming in the crontab format.

     If you turn on this toggle, in Execution, enter the string.

   • Task planning: The type of the vacuuming task.

     Possible values:

     • Execute now: Vacuuming will be performed immediately after you perform this instruction.

     • Time-delayed: Vacuuming will be performed at the specified date and time.

     • On schedule: Vacuuming will be performed at the specified time interval.

       For this value, specify the following parameters:

       • Interval: The unit of measurement of the time interval.

         Possible values:

         • Minutes

         • Hours

         • Days

       • Repeat every: The time interval for vacuuming by minutes or hours.

         This parameter is available only if you select Minutes or Hours from Interval.

       • Execution days: The days when vacuuming will be performed.

       • Cron total line: The string in the crontab format that specifies the time interval for vacuuming.

         The value is entered automatically.

     This parameter is available only if you turn off Set cron-string execution.

   • Name: The unique name of the vacuuming task.

     This parameter is available only if you turn on Set cron-string execution or select Time-delayed / On schedule from Task planning.

   • Time: The date and/or time when vacuuming will be performed.

     This parameter is available only if you select Time-delayed from Task planning or Days from Interval.

   • Start and Repeat untill: The start and end date and time for vacuuming.

     These parameters are available only if you turn on Set cron-string execution or select On schedule from Task planning.

5. Click Apply.

6. Confirm the operation.

Renaming a Database

The ALTER DATABASE SQL command is executed with the RENAME TO clause when renaming a database.

To rename a database:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click → Rename next to the database.

4. Specify the new database name.

5. Click Save.

Deleting a Database

The DROP DATABASE SQL command is executed when deleting a database.

To delete a database:

1. In the navigation panel, go to Databases.

2. (Optional) To display system databases, turn on Show system databases.

3. Click → Drop next to the database.

4. (Optional) To force delete the database, enable Forced deletion.

   If you enable this checkbox, all database connections will be terminated before deleting the database.

   The database will not be deleted if there are prepared transactions, logical replication slots, or subscriptions.

5. Click Delete.

6. Confirm the operation.