>From the prompt below, it looks like you're not connecting to the
dna_development database- the 'postgres=#' prompt should say
'dna_development=#'.
Can you try running the psql command and specifying the database ('psql
dna_development' or 'psql -d dna_development') and then running the
alter or grant command?
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Scott Olmsted
Sent: Monday, February 01, 2010 3:44 PM
To: [email protected]
Subject: RE: [SDRuby] Postgres problem
postgres=# grant all on table sessions to railsdev;
ERROR: relation "sessions" does not exist
postgres=# alter table sessions owner to railsdev;
ERROR: relation "sessions" does not exist
At 03:31 PM 2/1/2010, you wrote:
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]
<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>
<
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
<http://groups.google.com/group/sdruby>
--
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
<http://groups.google.com/group/sdruby>
--
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
--
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
