> > 2. How can I restrict connection to a certain
> > database (locally) on a user basis ? I mean,
> > I want to permit connection to mydb1 from user
> > user1 only and connection to mydb2 from user
> > user2 only..
>
> See pg_hba.conf into your data directory, all is here...
Sorry, use of GRANT will help you more...
Gilles