配置RubyMine与Heroku PostgreSQL的远程连接 [英] Configure RubyMine remote connection to Heroku PostgreSQL

问题描述

我应该如何配置RubyMine jdbc数据源以远程连接到Heroku的PostgreSQL数据库？目前我正在使用这样的连接URL：

  jdbc：postgresql：//ec2-54-197-241-67.compute- 1.amazonaws.com/dbqi9t12t5035q 
  

但是我收到主机缺少入口错误62.87.242.2 '在pg_hba.conf中。我很确定用户和密码是正确的，因为它在线运行... :-)。您可以帮我吗？

预先感谢您！

解决方案

在高级选项卡中，有一堆属性。设置以下属性：

  ssl  - > true 
 sslfactory  - > org.postgresql.ssl.NonValidatingFactory 
  

How should I configure RubyMine jdbc datasource to remotely connect to Heroku's PostgreSQL database? Currently I am using such connection URL:

jdbc:postgresql://ec2-54-197-241-67.compute-1.amazonaws.com/dbqi9t12t5035q

but I get error about lack of entry for host '62.87.242.2' in pg_hba.conf. I am pretty sure that user and password are correct, because it runs online... :-). Could you help me?

Thank you in advance!

解决方案

In the Advanced tab, there are a bunch of properties. Set the following properties:

ssl -> true
sslfactory -> org.postgresql.ssl.NonValidatingFactory

这篇关于配置RubyMine与Heroku PostgreSQL的远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！