ruby on rails - Using PG for ROR -
i using pg
in application
here database.yml file
default: &default adapter: postgresql pool: 5 timeout: 5000 development: <<: *default database: testing_development # warning: database defined "test" erased , # re-generated development database when run "rake". # not set db same development or production. test: <<: *default database: db/test.sqlite3 production: <<: *default database: db/production.sqlite3
when ran rake db:create
got:
pg::syntaxerror: error: syntax error @ or near "." line 1: create database "db/test"."sqlite3" encoding = 'utf8' ^ : create database "db/test"."sqlite3" encoding = 'utf8'
how fix this?
when running rake db:create
, tries create databases you, need name test
, production
databases properly. database names can't contain periods.
i.e., if application name testing
:
test: <<: *default database: testing_test production: <<: *default database: testing_production