Corda企业节点上的PostgreSQL引发关系错误 [英] PostgreSQL on Corda enterprise node throws relation errors

问题描述

在Docker容器中使用PostgreSQL运行Corda Enterprise.我已按照docs中的说明进行操作，并设置了数据库架构.在数据库启动时，我看到以下错误.有人可以帮忙那里发生的事情吗?

Running corda enterprise with PostgreSQL in docker container. I have followed the instruction in docs and have set database schema. On database start I see the following errors. Can anyone help what is going on there?

2018-10-11 06:57:57.491 UTC [1506] ERROR:  relation "node_checkpoints" does not exist at character 22
2018-10-11 06:57:57.491 UTC [1506] STATEMENT:  select count(*) from node_checkpoints
2018-10-11 06:58:22.440 UTC [1506] ERROR:  relation "corda-schema.databasechangeloglock" does not exist at character 22
2018-10-11 06:58:22.440 UTC [1506] STATEMENT:  select count(*) from "corda-schema".databasechangeloglock

推荐答案

似乎数据库用户名和架构名称没有相同的值，请通过以数据库管理员身份运行，确保为用户设置了正确的默认架构:

It seems the database user name and schema name don't have the same value, ensure that correct default schema is set for the user by running as database administrator:

ALTER ROLE "[USER]" SET search_path = "[SCHEMA]";

其他可能的问题是在模式名称中混合使用大小写和其他字符，是否可以确保模式名称具有所有小写字母(例如corda-schema而不是CORDA-SCHEMA或Corda-Schema).

Other possible issue is to mixing upper/lower case and other characters in schema name, could you ensure that schema name has all lower cases (e.g. corda-schema and not CORDA-SCHEMA or Corda-Schema).

这篇关于Corda企业节点上的PostgreSQL引发关系错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！