Install rails with WSL and postgresql

Question

I'm trying to setup a rails environment development on a Windows 10.

I follow the tutorial of 'go_rails' (https://gorails.com/setup/windows/10)

Most of the installation seems to worked fine (when i type rby -v or rails -v in the bash it's return the expected result).

My issue is with postresql which is used for the project i work on it.

Following the instructions of the tutorial i install Postgresql (10) directly on Windows. It's seems to work since in can login using the pgadmin on windows or by typing 'psql -p 5432 -h localhost -U postgres' in the bash.

So it's look like postgresql is working, but when i do a rake db:create in bash, i got an error : could not connect to the server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket '/var/run/postgresql/.s.PGSQL.5432'

In the postgresql.conf (C:/Programms/.../Data/postgresql.conf) the listen_addresses is set to '*'.

A bit after there is a line named '#unix_socket_directoris = ''', do you thing i should set something in there?

I really need to get that project work.

Thanks for your help

Jonathan P. · Accepted Answer · 2017-12-15 16:39:19Z

4

The problem is likely that you've installed the Windows binary for PostgreSQL, but you're trying to connect to it from Windows Subsystem for Linux using a Unix socket, which doesn't exist.

You need to use TCP/IP to connect rather than a Unix socket. When typing psql on the command line, add the option --host=127.0.0.1 to connect via TCP/IP.

answered Dec 15, 2017 at 16:39

Jonathan P.

411 bronze badge

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

2 Comments

Jay Killeen Over a year ago

Should we also then set in database.yml host: localhost or host: 127.0.0.1.

LordAlpaca Over a year ago

Any follow up in this solution?

Praveen Angyan · Accepted Answer · 2018-05-19 10:06:37Z

2

I just went through the entire Go Rails tutorial and I also had trouble at the rake db:create step. All you need to do is add host: 127.0.0.1 to your database.yml as shown below. Make sure to Start PostgreSQL before you run rake db:create.

default: &default
  host: 127.0.0.1
  adapter: postgresql
  encoding: unicode
  username: postgres
  password: ENV['POSTGRESQL_PASSWORD']
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>

development:
  <<: *default
  database: app_development

test:
  <<: *default
  database: app_test

production:
  <<: *default
  database: app_production
  username: app_username
  password: <%= ENV['APP_DATABASE_PASSWORD'] %>

answered May 19, 2018 at 10:06

Praveen Angyan

7,27531 silver badges35 bronze badges

Comments

mschultz · Accepted Answer · 2019-04-09 02:41:57Z

0

Add host: localhost to your default: in database.yml. Without something telling rails where to look for the host, it looks for the process in linux, which, of course, won't work, since windows processes are not exposed to the wsl layer.

answered Apr 9, 2019 at 2:41

mschultz

1,39513 silver badges21 bronze badges

Collectives™ on Stack Overflow

Install rails with WSL and postgresql

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related