Skip to content

Postgres compatibility for AWS DMS #34766

Closed
Closed
Postgres compatibility for AWS DMS#34766
Labels
A-sql-pgcompatSemantic compatibility with PostgreSQLC-wishlistA wishlist feature.O-communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)meta-issueContains a list of several other issues.
@bladefist

Description

@bladefist
bladefist
opened on Feb 10, 2019

Trying to use AWS Replication/Migration services and Cockroach as a target. The initial error I get is:


Endpoint identifier | Replication instance | Status | Failure message
-- | -- | -- | --
crdb | replication-server | failed | Test Endpoint failed: Application-Status: 1020912, Application-Message: postgres_set_encoding(...) faild in creating statement 'select character_set_name from information_schema.character_sets' ODBC general error., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 0A000 NativeError: 1 Message: ERROR: virtual schema table not implemented: information_schema.character_sets; No query has been executed with that handle ODBC general error.

Issue #8675 is aware of the missing character_set table, but once/if this error is resolved who knows how many more will come down the line. So this is a general request to make cockroach compatible with Amazon DMS (and ideally other competing services).
Thanks!

Epic CRDB-14124
Jira issue: CRDB-4627

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-pgcompatSemantic compatibility with PostgreSQLC-wishlistA wishlist feature.O-communityOriginated from the communityT-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)meta-issueContains a list of several other issues.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions