v1.21 is supposed to drop Postgres v9.6 support, but v12 scripts fail on CockroachDB

[dhiaayachi]

Expected Behavior

scripts to work on CRDB

Actual Behavior

ERROR Unable to update SQL schema. {"error": "error executing statement:pq: unimplemented: extension \"btree_gin\" is not yet supported", "logging-call-at": "handler.go:78"}

Steps to Reproduce the Problem

1. run ./temporal-sql-tool update-schema -schema-dir schema/postgresql/v96/temporal/versioned against a CRDB v22.2.7

Specifications

• Version: Temporal 1.20.1
• Platform: Linux

[dhiaayachi]

Thank you for reporting this issue.

It looks like you are experiencing an issue with the temporal-sql-tool when running it against a CRDB database. This is due to the fact that CRDB does not yet support the btree_gin extension which is needed for Temporal.

You can find more information about CRDB support in Temporal here.

Currently, Temporal officially supports the following database options:

• MySQL 5.7 (and later): temporal-sql-tool --pl mysql
• PostgreSQL 9.6 (and later): temporal-sql-tool --pl postgres
• Cassandra 3.11 (and later): temporal-cassandra-tool

Please let me know if you have any other questions.

[dhiaayachi]

Thank you for reporting this issue. The btree_gin extension is not yet supported by Temporal. We will add support for this feature in the future.

For now, you can work around this issue by using a different database, such as MySQL or Cassandra. Alternatively, you can use a different extension that is supported by Temporal.

Please let me know if you have any further questions.

[dhiaayachi]

Thank you for reporting the issue. It seems like you are trying to use temporal-sql-tool to update the schema on a CRDB database. CRDB is not supported. We recommend using Cassandra or MySQL/PostgreSQL to persist Temporal data.

If you need help using Cassandra or MySQL/PostgreSQL with temporal-sql-tool, please refer to the documentation here: Upgrade the Temporal Server.