# Postgresql error **URL:** \ **Category:** Rails\ **Created:** [January 16, 2010, 4:06pm UTC](https://www.ruby-forum.com/t/postgresql-error/181710 "2010-01-16T16:06:12Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![atheeq](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/3be4f8/32.png) [@atheeq](https://www.ruby-forum.com/u/atheeq)\ **Post date:** [January 16, 2010, 4:06pm UTC](https://www.ruby-forum.com/t/postgresql-error/181710/1 "2010-01-16T16:06:12Z")
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](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](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:in `new’ /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:in `initialize’ /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:in `initialize’ /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:in `connect’ /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:in `new’ /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:in `send’ /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:in `checkout\_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:in `loop’ /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:in `synchronize’ /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:in `connection’ /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:in `retrieve\_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:in `cache’ /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:in `call’ /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:in `call’ /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:in `call’ /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:in `call’ /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:in `synchronize’ /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:in `call’ /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:in `call’ /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:in `call’ /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:in `call’ /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:in `call’ /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:in `service’ /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start\_thread’ /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start\_thread’ /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each’ /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start’ /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:in `run’ /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:in `require’ 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:)