Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Full Synchronization Error: type 'hstore' does not exist

Updated on 2022-09-21 GMT+08:00

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.
    NOTE:

    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.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback