Try this from the psql prompt: ALTER TABLE sessions OWNER TO railsdev;
Alternatively, you could try: GRANT ALL ON TABLE sessions TO railsdev; -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scott Olmsted Sent: Monday, February 01, 2010 3:21 PM To: [email protected] Subject: Re: [SDRuby] Postgres problem pg_hba.conf: # Database administrative login by UNIX sockets local all postgres ident sameuser # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust At 03:13 PM 2/1/2010, you wrote: You didn't mention the pg_hba.conf file: < http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html <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 -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby
