Re: [OT?] permissions

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

In response to

Browse pgsql-sql by date

  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 ?)