Database connection error when setting up Discourse development environment using Linux Bash Shell on Windows 10

(Utsav Lamichane) #1

(error on this command)

bundle exec rake db:migrate db:test:prepare db:seed_fu

Beginners Guide to Install Discourse on Ubuntu for Development
(Blake Erickson) #2

Based on the error message

PG::ConnectionBad: could not connect to server

I would double check that psql is installed and running

(Utsav Lamichane) #3

plsql is installed and database is created as well. I think the problem is on connecting with port 5432. The powershell is showing the port active. But, inactive in UBUNTU for windows terminal

(Vinoth Kannan) #4

Did you followed this guide? Where your Postgres is running. In “Windows” or “Ubuntu for Windows”?

(Kyle Copeland) #5

I was able to figure out a solution to this issue.

When installing postgres, /etc/postgresql/10/main/postgresql.conf contained port=5433. Updating this to port=5432 fixed the issue for me. I ran into this when using Ubuntu on Windows.

Extra Credit:
Running sudo service postgresql status lets you know which port postgres is listening on.