Postgresql error

Hello,

I successfully dumped the database in postgresql. Now I want to connect
my rails application to the postgresql database, able to start the
server, but I am getting this error when I browse the application from
the browser.

script/server
=> Booting WEBrick
=> Rails 2.3.5 application starting on http://0.0.0.0:3000

Sphinx cannot be found on your system. You may need to configure the
following
settings in your config/sphinx.yml file:

  • bin_path
  • searchd_binary_name
  • indexer_binary_name

For more information, read the documentation:
http://freelancing-god.github.com/ts/en/advanced_config.html
=> Call with -d to detach
=> Ctrl-C to shutdown server
[2010-01-16 20:29:49] INFO WEBrick 1.3.1
[2010-01-16 20:29:49] INFO ruby 1.8.7 (2008-08-11) [i486-linux]
[2010-01-16 20:29:55] INFO WEBrick::HTTPServer#start: pid=5271
port=3000
/!\ FAILSAFE /!\ Sat Jan 16 20:30:03 +0530 2010
Status: 500 Internal Server Error
No such file or directory - /tmp/.s.PGSQL.5432
/usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/connection.rb:167:in
initialize' /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/connection.rb:167:innew’
/usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/connection.rb:167:in
establish_connection' /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/connection.rb:51:ininitialize’
/usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/postgres-compat.rb:23:in
new' /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/postgres-compat.rb:23:ininitialize’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
connect' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:968:inconnect’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:217:in
initialize' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:37:innew’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in
postgresql_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:insend’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
new_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:incheckout_new_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in
checkout' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:inloop’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
checkout' /usr/lib/ruby/1.8/monitor.rb:242:insynchronize’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
checkout' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:inconnection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
retrieve_connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:inretrieve_connection’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in
connection' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:9:incache’
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/query_cache.rb:28:in
call' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:incall’
/usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/string_coercion.rb:25:in
call' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:incall’
/home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:in
call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/params_parser.rb:15:incall’
/usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/session/cookie_store.rb:93:in
call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/failsafe.rb:26:incall’
/home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in
call' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:insynchronize’
/home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in
call' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:114:incall’
/usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/reloader.rb:34:in
run' /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/dispatcher.rb:108:incall’
/usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/static.rb:31:in
call' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:46:incall’
/home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
each' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:incall’
/usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/log_tailer.rb:17:in
call' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/content_length.rb:13:incall’
/home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:in
service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:inservice’
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in run' /usr/lib/ruby/1.8/webrick/server.rb:173:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start' /usr/lib/ruby/1.8/webrick/server.rb:162:instart_thread’
/usr/lib/ruby/1.8/webrick/server.rb:95:in start' /usr/lib/ruby/1.8/webrick/server.rb:92:ineach’
/usr/lib/ruby/1.8/webrick/server.rb:92:in start' /usr/lib/ruby/1.8/webrick/server.rb:23:instart’
/usr/lib/ruby/1.8/webrick/server.rb:82:in start' /home/atheeq/.gem/ruby/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:inrun’
/usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/commands/server.rb:111
/usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
script/server:3

and here is my database.yml file

development:
adapter: postgresql
username: postgres
password:
database: forum_release
encoding: utf8
#pool: 5
#timeout: 5000
#host: 127.0.0.1

Any help will be appreciated. Thanks in advance:)

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs