On Dec 16, 2011 5:46 AM, "Pandu Poluan" <pa...@poluan.info> wrote:
>
>
> 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...
>
Okay, I'm grasping at straws currently... how does the offending line in
admin.pl look like?
Rgds,
