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

[utsav_lamichane]

(error on this command)

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

[blake (Blake Erickson)]

Based on the error message

PG::ConnectionBad: could not connect to server

I would double check that psql is installed and running

[utsav_lamichane]

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

[vinothkannans (Vinoth Kannan)]

@utsav_lamichane

The powershell is showing the port active. But, inactive in UBUNTU for windows terminal

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

[DiscoStew (Kyle Copeland)]

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.