Re: Permissions to connect to postgres database

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