Updated on 2023-01-17 GMT+08:00

Full Synchronization Error: type 'hstore' does not exist

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=operator, index=2, schema_name=public, object_name=?|]reason:[ERROR: type 'hstore' does not exist].

Possible Causes

The hstore plug-in is not installed on the destination database.

Run the following SQL statement in the destination RDS PostgreSQL database:

select * from pg_extension where extname = 'hstore';

Solution

Extensions are not synchronized. Before synchronization, install the corresponding extension in the destination database. Perform the following steps to install the extension and retry the DRS task:

  1. Log in to the destination RDS PostgreSQL database as the root user.
  2. Run the following SQL statements to install hstore:

    create extension "hstore";

  3. Retry the DRS task.