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

[Joseph]

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