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.