Hi everyone,
Since a few days, i’m working on Vault in HA mode.
After trying with Consul (with success), i’m now trying with postgresql as a storage backend (still in HA).
But, no matter what I’m doing, it’s still not working and when I start Vault, it returns : storage migration check error: error=“pq: relation “vault_kv_store” does not exist” - I could undersand it if the table “vault_kv_store” was absent…but I created it.
Let me share the vault config file :
{
“listener”: {
“tcp”:{
“address”: “172.28.128.18:8200”,
“cluster_address”: “172.28.128.18.8201”,
“tls_disable”: 1
}
},
“storage”: {
“postgresql”: {
“connection_url”: “postgres://postgres:pw@172.28.128.21:5432/vault?search_path=vaultschema&sslmode=disable”,
“ha_enabled”: “true”,
“table”: “vault_kv_store”,
“ha_table”: “vault_ha_locks”
}
},
“storage_ha”: {
“postgresql”: {
“connection_url”: “postgres://postgres:pw@172.28.128.21:5432/vault?search_path=vaultschema&sslmode=disable”,
“table”: “vault_kv_store”
}
},
“ui”: true,
“api_addr”: “172.28.128.18:8200”,
“cluster_addr”: “172.28.128.18.8201”
}
and the screenshot below from my postgresql database :
I don’t know what I missing, if somebody could help me, it would great 