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
includedin 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@postgresql.org
--
joe speigle
www.sirfsup.com
