Re: opening postgresql first time

Bob,

the sameuser special map is shown in the pg_hba.conf above (see its last line which says:
local all ident sameuser
)
In other words, sameuser says that the os username must match the postgres username. It is a special ident map. If it's included in pg_hba.conf then it will preclude ident.conf from ever being checked.

pg_ident.conf allows mapping from one user to another user, from system user to postgresql user.

try just deleting that line from pg_hba.conf and SIGHUPPing i:)

On Wed, Apr 28, 2004 at 01:56:53PM +1200, Robert Morgan wrote:
> Hi have just installed postgres and tried to open it using: psql
> template1 postgres
> and get an error ident authentication failed.
>
> How do I open the dbms to add a user?
> Can I do it from the shell?
>
> Bob
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
joe speigle
www.sirfsup.com