I turned on log_connections and that is indeed the problem. Looks like it's my software and not pg.
Thanks all! Cheers, Ovid -- IT consulting, training, international recruiting http://www.allaroundtheworld.fr/. Buy my book! - http://bit.ly/beginning_perl Live and work overseas - http://www.overseas-exile.com/ On Thursday, 30 January 2014, 15:53, Adrian Klaver <adrian.kla...@gmail.com> wrote: On 01/30/2014 06:13 AM, Ovid wrote: >>> First: CREATE ROLE and CREATE DATABASE; >> >>> After: CREATE TABLEs; >> >>> Last: GRANT SELECT,INSERT,UPDATE and DELETE. >> >> OK, I dropped the database. Since I have the user already created, I >> recreated the database. Then I created all of the tables. Then I did this: >> >> postgres=# GRANT SELECT ON ALL TABLES IN SCHEMA public TO veure_user; >> GRANT >> postgres=# GRANT INSERT ON ALL TABLES IN SCHEMA public TO veure_user; >> GRANT >> postgres=# GRANT UPDATE ON ALL TABLES IN SCHEMA public TO veure_user; >> GRANT >> postgres=# GRANT DELETE ON ALL TABLES IN SCHEMA public TO veure_user; >> GRANT >> >> Same error: permission denied for relation "users". And when I do \dt: >> >> Schema | Name | Type | Owner >> --------+-------------------+-------+------------ >> public | users | table | veure_user >> >> So I'm still missing something here :) > >I would tend to go with Raymond, are you sure about the user you are >connecting as? > >It would be helpful to tail the Postgres log and see what the connection >info is. > >> >> I'm sure my password is correct because this works (password in .pgpass, >> though the fact that I'm connecting suggests that my password is fine): >> >> $ psql -U veure_user -d veure >> psql (9.1.11) >> Type "help" for help. > > >Well if your pg_hba.conf is the same as before : > >local all veure_user trust > >than a password is not being used. So connecting does not prove a valid > >password. > >> >> Cheers, >> Ovid >> > >-- >Adrian Klaver >adrian.kla...@gmail.com > > > >
