On Feb 1, 2010, at 14:53 , Scott Olmsted wrote: > I've taken on a new client with a Postgres database. First time using > Postgres for me. > > The app boots in Rails, but the first request produces: > > SQL (0.4ms) SET client_min_messages TO 'panic' > SQL (0.1ms) SET client_min_messages TO 'notice' > 2010-02-01 13:21:28 [FATAL] /!\ FAILSAFE /!\ Mon Feb 01 13:21:28 -0800 2010 > Status: 500 Internal Server Error > PGError: ERROR: permission denied for relation sessions > : SELECT * FROM "sessions" WHERE (session_id = > E'afd988ab22e046dfcb7283917a71d0de') LIMIT 1 > > /usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in > `log'
You didn't mention the pg_hba.conf file: <http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html> Have you got that set up? Regards, Guyren G Howe Relevant Logic LLC guyren-at-relevantlogic.com ~ http://relevantlogic.com ~ +1 512 784 3178 Ruby/Rails, REALbasic, PHP programming PostgreSQL, MySQL database design and consulting Technical writing and training Read my book, Real OOP with REALbasic: <http://relevantlogic.com/oop-book/about-the-oop-book.php> -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby
