Connecting to Rails app Postgres DB using pgAdmin

Question

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.

bwvoss · Accepted Answer · 2011-06-01 00:28:26Z

4

Try adding a port to your development.yml file. Especially if you run a windows OS.

The default port is port:5432 and I'm not sure if specifying the port:3000 in your pgAdminIII would cause problems.

answered Jun 1, 2011 at 0:28

bwvoss

1101 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Danny Hiemstra · Accepted Answer · 2011-02-22 15:26:11Z

4

Can you try to use 127.0.0.1 instead of localhost? I know mysql often causes problems that it will try to connect to the socket file instead of making a TCP connection.

answered Feb 22, 2011 at 15:26

Danny Hiemstra

1,1881 gold badge9 silver badges13 bronze badges

2 Comments

Lee McAlilly Over a year ago

Thanks for the comment Danny, I tried using 127.0.0.1 instead of localhost and that did not work either.

Jesper Rønn-Jensen Over a year ago

host: 127.0.0.1 instead of localhost worked for me on my mac. Thanks a lot for this tip!

Collectives™ on Stack Overflow

Connecting to Rails app Postgres DB using pgAdmin

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related