On Dec 15, 2011 8:52 PM, "Joseph" <syscon...@gmail.com> wrote: > > On 12/15/11 16:11, Pandu Poluan wrote: >> >> >> Hmmm... >> >> Have you GRANT the 'sql-ledger' user the CONNECT privilege to the >> database? >> >> Rgds, > > > After installing postgresql I run: > emerge --config =dev-db/postgresql-server-9.1.1 > > started postgresql-9.1 > # su - postgres > postgres@syscon5 ~ $ createuser -d sql-ledger > y > y > exit > > that was it. > > # psql -U postgres -l > List of databases > Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + > | | | | | postgres=CTc/postgres > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + > | | | | | postgres=CTc/postgres > -- > Joseph >
Okay, according to the documentation on GRANT, "=c/postgres" means the public is granted "CONNECT" privilege, granted by the user postgres. So no problem there. Hmm... wonder what's wrong... Rgds,