I’ve been going through the book and creating the shine app on my windows 10 machine. Everything has been working fine for the most part but I’ve come across a slight stumbling block. I installed PostgreSQL 9.6 on my machine and am using pgAdmin to check tables and perform SQL related tasks. Now I’ve come across a part in the book where the db/schema.rb file is removed and a rails db:migrate command is run to create the db/structures.sql file. When I run this command from my command prompt I am getting an error saying that pg_dump does not exist. I have set my PATH environment variable to the bin directory of my PostgreSQL installation but the problem persists. I believe it has to do with rails trying to execute “pg_dump” and not “pg_dump.exe” because when I run the latter command from the shine rails app directory it is found and asks for a password.
Is there a way to modify the canned rails script to force “pg_dump.exe” to be run instead of just “pg_dump”?
Thanks in advance for your help! –Nick