Hi Team, Please advise the error. -- create default records for datahub user if not exists CREATE TEMP TABLE temp_metadata_aspect_v2 AS TABLE metadata_aspect_v2; INSERT INTO temp_metadata_aspect_v2 (urn, aspect, version, metadata, createdon, createdby) VALUES( 'urnlicorpuser:datahub', 'corpUserInfo', 0, '{"displayName":"Data Hub","active":true,"fullName":"Data Hub","email":"datahub@linkedin.com"}', now(), 'urnlicorpuser:__datahub_system' ), ( 'urnlicorpuser:datahub', 'corpUserEditableInfo', 0, '{"skills":[],"teams":[],"pictureLink":""}', now(), 'urnlicorpuser:__datahub_system' ); -- only add default records if metadata_aspect is empty INSERT INTO metadata_aspect_v2 SELECT * FROM temp_metadata_aspect_v2 WHERE NOT EXISTS (SELECT * from metadata_aspect_v2); DROP TABLE temp_metadata_aspect_v2; psql: error: connection to server at "10.240.154.202", port 5432 failed: FATAL: database "datahub" does not exist 2022/09/01 133151 Command exited with error: exit status 2

please share the values for sql that you have set in datahub values.yaml . make sure to omit the secrets

we use postgres

i mean the config for this block i values.yaml https://github.com/acryldata/datahub-helm/blob/master/charts/datahub/values.yaml#:~:text=sql%3A,mysql%2Droot%2Dpassword

Quick connect for 2 min pls

please go through this thread , it may help https://datahubspace.slack.com/archives/CV2UVAPPG/p1658173279061999

we use postgres.. and the details are as per below. postgres: datasource: host: "10.240.154.202" hostForpostgresqlClient: "10.240.154.202" port: "5432" url: "jdbc:postgresql://10.240.154.202:5432/dcflow?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2" driver: "org.postgresql.Driver" username: "dcflow_rw" password: secretRef: postgres-dcflow-secrets secretKey: postgres-dcflow-password optional: false

make below chanes

postgres: --> change it to sql 
    datasource:
      host: "10.240.154.202"   --> ""10.240.154.202:5432"
      hostForpostgresqlClient: "10.240.154.202"
      port: "5432"
      url: "jdbc:<postgresql://10.240.154.202:5432/dcflow?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2>"
      driver: "org.postgresql.Driver"
      username: "dcflow_rw"
      password:
        secretRef: postgres-dcflow-secrets
        secretKey: postgres-dcflow-password
        optional: false (edited)

Doing it. Thank you!

yes keep database name and username same

yes dbname is dcflow.

change db to

url: "jdbc:<postgresql://10.240.154.202:5432/dcflow_rw?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2>"

Is this fine? sql: enabled: true datasource: host: "10.240.154.202:5432" hostForpostgresqlClient: "10.240.154.202" port: "5432" url: "jdbc:postgresql://10.240.154.202:5432/dcflow_rw?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2" driver: "org.postgresql.Driver" username: "dcflow_rw" password: secretRef: postgres-dcflow-secrets secretKey: postgres-dcflow-password optional: false

yes

let me commit and proceed..

as discussed create database and db user with name

dcflow

I made db name change in gms values.yml still getting below error, advise us where it getting it from. WHERE NOT EXISTS (SELECT * from metadata_aspect_v2); DROP TABLE temp_metadata_aspect_v2; psql: error: connection to server at "10.240.154.202", port 5432 failed: FATAL: database "datahub" does not exist 2022/09/02 094640 Command exited with error: exit status 2