github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/docs/user_docs/kubeblocks-for-postgresql/migration/feature-and-limit-list-pg.md (about)

     1  ---
     2  title: Full feature and limit list
     3  description: The full feature and limit list of KubeBlocks migration function for PostgreSQL
     4  keywords: [postgresql, migration, migrate data in PostgreSQL to KubeBlocks, full feature, limit]
     5  sidebar_position: 1
     6  sidebar_label: Full feature and limit list
     7  ---
     8  
     9  # Full feature and limit list
    10  
    11  ## Full feature list
    12  
    13  * Precheck
    14    * Database connection
    15    * Database version
    16    * Whether the incremental migration is supported by a database
    17    * The existence of the table structure
    18    * Whether the table structure of the source database is supported
    19  * Structure initialization
    20    * PostgreSQL
    21      * Table Struct
    22      * Table Constraint
    23      * Table Index
    24      * Comment
    25      * Table Sequence
    26  * Data initialization
    27    * Supports all major data types
    28  * Incremental data migration
    29    * Supports all major data types
    30    * Support the resumable upload capability of eventual consistency
    31  
    32  ## Limit list
    33  
    34  * Overall limits
    35    * If the incremental data migration is used, the source database should enable CDC (Change Data Capture) related configurations (both are checked and blocked in precheck).
    36    * A table without a primary key is not supported. And a table with a foreign key is not supported (both are checked and blocked in precheck).
    37    * Except for the incremental data migration module, other modules do not support resumable upload, i.e. if an exception occurs in this module, such as pod failure caused by downtime and network disconnection, a re-migration is required.
    38    * During the data transmission task, DDL on the migration objects in the source database is not supported.
    39    * The table name and field name cannot contain Chinese characters and special characters like a single quotation mark (') and a comma (,).
    40    * During the migration process, the switchover of primary and secondary nodes in the source library is not supported, which may cause the connection string specified in the task configuration to change. This further leads to migration link failure.
    41  * Precheck module: None
    42  * Structure initialization module
    43    * The Array data type is not supported, such as text[], text[3][3], integer[].
    44    * The user-defined type is not supported.
    45    * The database character set other than UTF-8 is not supported.
    46  * Data initialization module
    47    * Character sets of the source and sink databases should be the same.
    48  * Data incremental migration module
    49    * Character sets of the source and sink databases should be the same.