I’m relatively new to Ruby and Rails. I’m working with PostgreSQL
successfully as a development database server, and I want to use it in
production and testing as well. My development server is called
(myapp)_dev. My test database server is called (myapp)_test. Both exist
on the same machine and both were created using the createdb PostgreSQL
I can’t connect to the test database using rake db:test:prepare. The
message that shows up in my pgsql logfile is “FATAL: database
(myapp)_test does not exist”. Yet if I try to create a database with
that name using the createdb function, this shows up in my log: “ERROR:
(myapp)_test already exists”.
I’m sure it’s something simple that I’m doing wrong, but I can’t figure
out what. Any help is appreciated.
Using Ruby 1.8.7, Rails 2.3.5, PostgreSQL 8.4.2 and Mac OS X Snow