Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

[Pandu Poluan]

On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@×××××.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,