Temporal connectivity with local cockroachdb (single-node)

Community Support
,
1

Hi temporal community,

I am very new to this temporal space. Just now I am trying to getting started to understand things in Temporal. Now I want to use some persistent store to work with temporal. I am running my cockroachdb instance in local running on port localhost:26257. I’ve set up temporal schema to be available in local DB by using this link

Following is my development.yaml configuration for local

server:
  config:
    persistence:
      defaultStore: default
      visibilityStore: visibility
      datastores:
        default:
          sql:
            pluginName: "postgres"
            databaseName: "temporal"
            connectAddr: "localhost:26257"
            user: "root"
            password: ""
            tls:
              enabled: false
        visibility:
          sql:
            pluginName: "postgres"
            databaseName: "temporal_visibility"
            connectAddr: "localhost:26257"
            user: "root"
            password: ""
            tls:
              enabled: false

Also I have stored some env information in my Mac such as:

export TEMPORAL_CLI_CONFIG=/Users/demo/temporal/config/development.yaml
export TEMPORAL_CLI_ENV=development

When I am running my local using temporal server start-dev, it’s not working. It’s only using the in-memory database. Kindly provide me some valuable suggestion or checklist if any about how could I get this thing done on my local. Thanks.

Note: There is no cockroachdb available in the tag so I used postgres