Successfully!

Error!

Configure PostgreSQL Databases

  • Last update:  2024-01-30
  • Overview

    Version

    Report Server Version

    PostgreSQL External   Database Plugin Version

    Functional Change

    11.0

    V1.0.0

    /

    11.0

    V1.0.2

    (1) Supported automatic reading of the database mode to prevent errors caused by manual input.

    (2) Automatically checked whether the project versions corresponding to the old and new databases are   consistent when data is migrated to the external database and Migrate Data to Database to Be Enabled is not selected.

    11.0

    V1.0.3

    Supported PostgreSQL databases of the 13.0 version.

    11.0.3

    V1.0.3

    (1) Allowed you to determine whether to select Migrate Data to Database to Be Enabled when configuring an external database for the first time.

    (2) Refined the prompts displayed in the process of migrating data to external databases for you to better understand the migration progress.

    Function Description

    If an external database is configured for the report system, the report system will become more stable in cluster environments or situations with large amounts of data.

    You can configure PostgreSQL databases in the decision-making system by installing the PostgreSQL External Database plugin.

    iconNote:

    If the external database is configured, do not modify the username and password of the external database. Otherwise, project startup will fail.

    If you need to modify them, see Modifying the Account and Password of the External Database.

    Notes

    If the report project is configured with a virtual directory, namely, the decision-making system can be accessed through IP addresses in Tomcat, you need to modify the server configuration file before installing the plugin.

    Open the %tomcat_home%\conf\server.xml file and modify the value of reloadable to false, as shown in the following figure.

    External Database Preparation

    To prepare the database to which platform data will be migrated, you are advised to create an empty database. (For details about the database size, see "Hardware Configuration.")

    iconNote:
    Different FineReport projects cannot share the same external database. Otherwise, data may become disordered.

    Database Version

    The following table describes the types and versions supported by the external database.

    Database Type
    Report Server VersionPlugin VersionSupported Database Version

    PostgreSQL

    11.0

    V1.0

    9.4.7/9.5.0/9.5.2/9.6.0

    PostgreSQL

    11.0

    V1.0.3

    9.4.7/9.5.0/9.5.2/9.6.013.0

    Hardware Configuration

    Configuration Type
    Minimum ConfigurationRecommended Configuration

    Memory

    1 GB

    2 GB

    CPU

    4 cores

    8 cores

    Internet speed

    50 Mbps

    100 Mbps

    FineDB-occupied space

    1 GB

    2 GB

    Server disk space

    100 GB

    200 GB

    Disk read/write speed

    50 MB/s

    100 MB/s


    iconNote:

    1. You need to modify the occupied space according to the usage rate. You can configure the space to be one to two times larger than the size of the finedb folder in webapps/webroot/WEB-INF/embed (estimated size based on the actual size).

    2. You are advised to use the memory with the same size of the memory reserved for the project configuration library.

    3. The external database should be in the same network segment as the report project to avoid network fluctuations.

    External Database Configuration

    Plugin Installation

    You can contact our technical support to obtain the plugin.

    For details about how to install the plugin in the designer, see Designer Plugin Management.

    For details about how to install the plugin on the server, see Server Plugin Management.

    External Database Configuration Entry

    Log in to the decision-making system as the admin, choose System Management > System Setting > General > External Database, as shown in the following figure.

    图3.png

    External Database Configuration

    After entering the external database configuration page, select the database type and enter the corresponding information of the actual database, as shown in the following figure.

    图4-FR (PostgreSQL).png

    Setting Item

    The following table describes each setting item.

    Setting Item
    Description

    Database Type

    Select PostgreSQL.

    Driver

    This parameter will be automatically set, requiring no modification.

    Database Name

    For details, see the database name in section "External Database Preparation."

    iconNote:

    Your project must not share the database with other projects. You are advised to create a database.

    The database name can contain only numbers, letters, underscores, and periods (.).


    Username/Host/Password/Port

    Set these parameters according to the actual database information.

    iconNote:

    The host name can contain only numbers,   letters, underscores, hyphes (-), and periods (.).

    You need to have the createdeletealterupdateselectinsert, and index permissions.


    Mode

    You can select a mode from the drop-down list.

    After correctly setting the above parameters, select Click to Connect Database from the drop-down list. The system will automatically connect to the database and read modes. You just need to select a node (better select the one corresponding to the database username).

    iconNote:
    If a prompt indicating database connection failure is displayed, check the settings above.


    图5.png

    Migrating Data to the Database to Be Enabled

    You can determine whether to select Migrate Data to Database to Be Enabled based on your own needs. The following describes the details:

    (1) Select Migrate Data to Database to Be Enabled when the new external database is empty.

    After you click Enable New Database, the platform data of the original FineDB database will be migrated to the new external database.

    (2) Select Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.

    After you click Enable New Database, the message "The platform data already exists in the database. Before data import, the original platform data will be cleared. Sure to connect to the database?" pops up.

    After you click OK, the original platform data will be cleared, and the platform data of the original FineDB database will be migrated to the new external database.

    图6.png

    (3) Deselect Migrate Data to Database to Be Enabled when the new external database is empty.

    After you click Enable New Database, the message "The target database is a new database and can be used after the current data is migrated to the target database." pops up.

    After you click Migrate and Enable, the platform data of the original FineDB database will be migrated to the new external database.

    图7.png


    (4) Deselect Migrate Data to Database to Be Enabled when the platform data already exists in the new external database.

    After you click Enable New Databasethe project will automatically detect whether the JAR package version corresponding to the data in the target database is consistent with that in the current project.

    ·        If the versions are inconsistent, the message "Unable to enable it. Project version required to enable the new database: xxx Current project version: xxx Ensure that the project version is consistent." is displayed. In this case, you fail to configure external databases.

    图8.png


    ·        If the JAR package versions are consistent and the original FineDB database is a built-in database, the new external database is enabled directly.

    ·        If the JAR package versions are consistent and the original FineDB database is an external database, the configuration information of the original database is automatically backed up before migration (as result of which the db.properties.bak file is generated in webapps\webroot\WEB-INF\config), and the new external database is enabled directly.

    图9.png

    Successful Migration

    Wait until the migration is successful. Different pop-up prompts may appear depending on the migration situation.

    (1) New external database using data of the original FineDB database

    The message "The target database has been enabled successfully." pops up. Click OK to complete the migration.

    图10.png

    (2) New external database using data of the original FineDB database (which is a built-in database)

    The message "Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use." pops up.

    Click OK and restart the report project to complete the migration.

    图11.png

    (3) New external database using data of the original FineDB database (which is an external database)

    The following two messages pop up:

    ·        Successfully switched to the target database. If data is different between the old and new databases, system running may be affected. You are advised to restart the project for normal use.

    ·        The original database configuration has been backed up to the config folder. You can use the backup file to restore the database configuration if necessary.

    Click OK and restart the report project to complete the migration.


    图12.png

    Deleting Built-in Database Data Connections

    The built-in FineDB database is an HSQL database that creates an in-memory database when used, which will occupy a large amount of memory when the data volume is large.

    Therefore, after configuring the external database, check whether a data connection exists for the built-in FineDB database in Data Connection.

    If so, delete the data connection in time. Otherwise, the connection will continue to occupy server memory.

    图13.png

    Attachment List


    Theme: Decision-making Platform
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback