我尝试使用 SchemaSpy 连接到我的 PostgresSQL 服务器。我安装了 Java 使用oracle-java8-installer
from ppa:webupd8team/java.
(我的 PostgreSQL 服务器在 Docker 容器上运行,因此我将端口转发到 5431)
My schemaspy.properties
文件是:
# type of database. Run with -dbhelp for details
schemaspy.t=pgsql
# optional path to alternative jdbc drivers.
# database properties: host, port number, name user, password
schemaspy.host=localhost:5431
schemaspy.port=5431
schemaspy.db=dbname
schemaspy.u=dbuser
schemaspy.p=dbpassword
# output dir to save generated files
schemaspy.o=dbschema
# db scheme for which generate diagrams
schemaspy.s=public
当我运行这个命令时:
java -jar schemaspy-6.0.0.jar -configFile schemaspy.properties
我确信可以在 localhost:5431 上访问数据库。但是我收到:
user@hostname:~/path-to-app$ java -jar schemaspy-6.0.0.jar -configFile schemaspy.properties
____ _ ____
/ ___| ___| |__ ___ _ __ ___ __ _/ ___| _ __ _ _
\___ \ / __| '_ \ / _ \ '_ ` _ \ / _` \___ \| '_ \| | | |
___) | (__| | | | __/ | | | | | (_| |___) | |_) | |_| |
|____/ \___|_| |_|\___|_| |_| |_|\__,_|____/| .__/ \__, |
|_| |___/
6.0.0
SchemaSpy generates an HTML representation of a database schema's relationships.
SchemaSpy comes with ABSOLUTELY NO WARRANTY.
SchemaSpy is free software and can be redistributed under the conditions of LGPL version 3 or later.
http://www.gnu.org/licenses/
INFO - Starting Main v6.0.0 on hostname with PID 18555 (/home/user/path-to-app/schemaspy-6.0.0.jar started by user in /home/user/path-to-app)
INFO - The following profiles are active: default
INFO - Found configuration file: schemaspy.properties
INFO - Started Main in 3.406 seconds (JVM running for 4.519)
INFO - Starting schema analysis
WARN - Connection Failure
我应该添加驱动程序吗?我尝试过postgresql-42.2.4.jar
。我从下载的jdbc.postgresql.org https://jdbc.postgresql.org/download.html站点并将此行添加到配置文件中。
schemaspy.dp=postgresql-42.2.4.jar
但是它仍然显示相同的错误。