How do i turn on the connection logging and then how do you actually check
it?
On 7/27/06, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> Jasbinder Bali wrote:
> > Hi,
> > I have a database in postgres and i've given trusted permissions to all
> > making required changes
> > in pg_hba.conf.
> >
> > Now, I'm trying to connect to the database using ECPG. Unfortunately
> after
> > EXEC SQL CONNECT dbxyz
> > gives me error -402 that means i don't have permissions to the database.
>
> If you turn on connection logging on the postgresql server you'll see
> what's happening. Don't forget system users and postgresql users aren't
> connected.
>
> --
> Richard Huxton
> Archonet Ltd
>