Re: [OT?] permissions - Mailing list pgsql-sql

From Clayton Cottingham aka drfrog
Subject Re: [OT?] permissions
Date
Msg-id 200111200131.fAK1VmT09272@smartt.com
Whole thread Raw
In response to Re: [OT?] permissions  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Thanks Peter:


On Mon, 19 Nov 2001 15:40:12 +0100 (CET), Peter Eisentraut said:

>  > so i try
>  >
>  > #local ident not avail! right?
>  > host         all     127.0.0.1     255.255.255.255     ident     postgres
>  >
>  > and get this
>  > psql: No pg_hba.conf entry for host localhost, user postgres, database postgres
>  > even though it says 'all'
>  
>  I don't know if it's the cause of the message, but 'ident postgres'
>  doesn't seem right.  The word after ident is not a user name.
>  

doh!
ok 

those names are just mappings for pg_ident.conf
correct or the special name sameuser

are there any other keywords i should know?


>  > one would think there should be an extra option on this of user to connect
>  >
>  > like
>  >
>  > local         mydb                 password passwd myuser
>  > host         mydb       127.0.0.1     255.255.255.255    password passwd
>  > myuser
>  
>  There is:  You only list the users you want to be able to get in in the
>  'passwd' file.
>  

ah yes
as soon as i read this i was oh yeah sort of  like apache !


Thanks Again





pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: why does this query does not work??????
Next
From:
Date:
Subject: Re: Foreign Key Constraint Deletion Order