From: | "Clayton Cottingham aka drfrog" <drfrog(at)smartt(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: [OT?] permissions |
Date: | 2001-11-19 17:20:18 |
Message-ID: | 200111200131.fAK1VmT09272@smartt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-11-19 21:16:56 | Re: why does this query does not work?????? |
Previous Message | Roberto Mello | 2001-11-19 15:35:47 | Re: persistent connections, AOLserver (Was: [SQL] maybe Offtopic : PostgreSQL & PHP ?) |