Assess a PostgreSQL database|V4.4.2|OceanBase Migration Assessment|docs|OceanBase Documentations

In the assessment of a PostgreSQL database, only objects are assessed.

Prerequisites

OceanBase Migration Assessment (OMA) is installed. For more information, see Install OMA.

Grant user privileges

Grant user the required privileges to connect to the database.

GRANT CONNECT ON DATABASE <your_database> TO <user_name>;

Grant user the USAGE privilege on the schema.

GRANT USAGE ON SCHEMA <schema_name> TO <user_name>;

Assign a monitoring role (containing all required privileges) to the user.
```
GRANT pg_monitor TO <user_name>;
```

Grant user the query privilege on system catalogs.

GRANT USAGE ON SCHEMA pg_catalog TO <user_name>;

Grant user the required privileges to execute the system functions.

GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pg_catalog TO <user_name>;

Run the assessment command

Go to the installation directory of OMA and run start.sh with reference to the following sample statement. For more information about the parameters in the statement, see Product form. In Microsoft Windows, replace sh bin/start.sh with start.bat.

sh bin/start.sh \
# The task name, which can be set to any value.
--name testPG \
# The assessment mode. ANALYZE_TOTAL indicates a database assessment.
--mode ANALYZE_TOTAL \
# The assessment type. Only OBJECT is supported.
--analyze-types OBJECT \
# The data source. DB indicates a database.
--from-type DB \     
# The assessment mode.
--evaluate-mode SOURCE_TARGET \
# The type of the source database.
--source-db-type POSTGRESQL \        
# The version of the source database.
--source-db-version 10 \        
# The address of the source database.
--source-db-host xxx.xxx.xxx.xxx \  
# The port of the source database.
--source-db-port port \    
# The username of the source database.
--source-db-user username \       
# The password of the source database.
--source-db-password password \       
# The schema to be assessed. dbName specifies the name of the database to be assessed. Separate multiple schemas with commas (,).
--schemas "dbName1.s1,dbName2.s2" \     
# The type of the target database.
--target-db-type OBMYSQL \    
# The version of the target database, including 2.2.50, 2.2.70, 3.1.20, 4.2.x, 4.3.5, and 4.4.2.
# 2.2.50 represents the 2.2.5x versions, 2.2.70 represents the 2.2.7x versions, 3.1.20 represents the 3.1.x versions, and 4.2.x represents 4.2.0, 4.2.1, 4.2.2, and 4.2.5.
--target-db-version 4.3.5

After you run the preceding commands, you can view the progress in real time.

View an assessment report

After the assessment is completed, OMA generates an assessment report in the .pdf format in the report directory and an assessment report in the HTML format in the reportTool directory.

To view the assessment report in the .pdf format, go to the report directory and open the PDF file of the name in the path displayed in the CLI.
To view the assessment report in the HTML format, perform the following steps:
1. Go to the reportTool directory, double-click the index.html file.
2. On the page that appears, click Authorize and View Report.
3. Select and open the oma.sqlite file.
  
  Generally, the oma.sqlite file is stored in the db folder under the root directory of OMA.
4. On the page that appears after you open the oma.sqlite file, click Select Report in the upper-right corner and select the migration assessment report that you want to view from the drop-down list.