擅长:python、mysql、java
<p>之所以发生这种情况,是因为psycopg2试图通过SSL连接到AWS Postgresql,但失败了</p>
<ol>
<li>尝试使用sslmode=disable连接
<pre><code>def getConection(self):
self.conn = psycopg2.connect(database=self.database,
user = self.user,
password = self.password,
host = self.host,
port = "5432",
sslmode="disable")
return self.conn
</code></pre>
</li>
<li>如果AWS Postgresql配置为强制ssl连接,即参数<code>rds.force_ssl</code>=1,则方法1将不起作用。如果启用set<code>rds.force_ssl</code>,则拒绝所有非SSL连接。在这种情况下,请尝试使用以下方式进行连接:</li>
</ol>
<p><code>$ psql -h testpg.cdhmuqifdpib.us-east-1.rds.amazonaws.com -p 5432 "dbname=testpg user=testuser sslrootcert=rds-ca-2015-root.pem sslmode=verify-full"</code></p>
<p>有关如何使用各种驱动程序通过ssl连接到AWS RDS的详细信息:<a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL.Requiring" rel="nofollow noreferrer">AWS RDS SSL</a></p>