如果在Heroku上使用Publify，如何配置database.yml文件使用PostgreSQL？

Question

我正在学习http://fdv.github.io/publify/#publifydemo的教程，但它说的是

1. 将database.yml.yourEngine重命名为database.yml
2. 编辑database.yml以添加数据库名称、登录名和密码。

因此，我将database.postgresql.yml重命名为database.yml，并添加了登录名和密码，下面是文件

login: &login
  adapter: postgresql
  host: localhost
  username: troll

development:
  encoding: unicode
  database: typo_dev
  username: troll
  password: lol
  host: localhost:3000

test:
  encoding: unicode
  database: typo_dev
  username: troll
  password: lol
  host: localhost:3000

production:
  database: typo
  username: troll
  password: lol
  host: <hostname or ip address. eg.: localhost>

不太确定从这里往哪里走。我确实搜索了PostgreSQL文档，但不知道从哪里开始从手册的2808页开始。

我确实遇到了这个问题，如何使用rails项目配置Postgresql？，但它仍然没有在本地运行

这是我运行rails服务器时的日志。

jgallardo:bruxir-typo juan.gallardo$ rails server
/Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/2.0.0/psych.rb:205:in `parse': (<unknown>): found character that cannot start any token while scanning for the next token at line 2 column 3 (Psych::SyntaxError)
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/2.0.0/psych.rb:205:in `parse_stream'
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/2.0.0/psych.rb:153:in `parse'
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/2.0.0/psych.rb:129:in `load'
from /Users/juan.gallardo/Desktop/myfiles/test-projects/typo/bruxir-typo/Gemfile:7:in `eval_gemfile'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler/dsl.rb:30:in `instance_eval'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler/dsl.rb:30:in `eval_gemfile'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler/dsl.rb:9:in `evaluate'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler/definition.rb:19:in `build'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler.rb:148:in `definition'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-1.3.5/lib/bundler.rb:136:in `load'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/bundler-unload-1.0.1/lib/bundler-unload.rb:42:in `with_bundle'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/rubygems-bundler-1.2.2/lib/rubygems-bundler/noexec.rb:53:in `candidate?'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/rubygems-bundler-1.2.2/lib/rubygems-bundler/noexec.rb:70:in `setup'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/gems/rubygems-bundler-1.2.2/lib/rubygems-bundler/noexec.rb:85:in `<top (required)>'
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:116:in `require'
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:116:in `rescue in require'
from /Users/juan.gallardo/.rvm/rubies/ruby-2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:122:in `require'
from /Users/juan.gallardo/.rvm/gems/ruby-2.0.0-p195/bin/ruby_noexec_wrapper:9:in `<main>'

Answer 1

不确定这是否是问题所在，但是主机和端口应该是这样的：

host: localhost
port: 3000

我不认为这会起作用：

host: localhost:3000