使用 pgAdmin 连接到 Rails 应用程序 Postgres DB

发布于 2024-10-18 12:02:46 字数 696 浏览 1 评论 0原文

我在使用 pgAdmin 连接到 Rails 应用程序的数据库时遇到问题。我的服务器正在运行，并且我相信 pgAdmin 中的服务器属性是正确的。这是我在 pgAdmin 服务器属性中的内容：

Name: achievenext_dev
Host: localhost
port: 3000
SSL:
Maintenance DB: postgres
username: achievenext
password: ******
Store password: true
Restore env?: true
DB Restriction: 
Service:
Connect now: true

在我的 database.yml 文件中：

development:
  adapter: postgresql
  host: localhost
  username: achievenext
  password: ******
  database: achievenext_dev

但是当我尝试连接 pgAdmin 时返回此错误：

发生错误：
连接到服务器时出错：服务器意外关闭连接。这可能意味着服务器在处理请求之前或处理过程中异常终止。

但我的服务器上没有任何错误。它似乎运行良好。无法弄清楚我在这里做错了什么。

原文

I'm having trouble connecting to the database for my Rails app using pgAdmin. I have the server running and I believe that my server properties are correct in pgAdmin. Here's what I have in pgAdmin server properties:

Name: achievenext_dev
Host: localhost
port: 3000
SSL:
Maintenance DB: postgres
username: achievenext
password: ******
Store password: true
Restore env?: true
DB Restriction: 
Service:
Connect now: true

And in my database.yml file:

development:
  adapter: postgresql
  host: localhost
  username: achievenext
  password: ******
  database: achievenext_dev

But when I try to connect pgAdmin returns this error:

An error has occurred:
Error connecting to the server: server
closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request.

But there are no errors on my server. It appears to be running fine. Can't figure out what I'm doing wrong here.

分享到QQ

分享到微博