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
