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

I don't know if this is the best way to do it, but I become root and
then 'su postgres'. This makes you the postgres user at which point
you can add the user.

Avi

On Apr 27, 2004, at 20:56, Robert Morgan wrote:


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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:
--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

it should be psql -d template1 postgres no?
On Wed, Apr 28, 2004 at 01:56:53PM +1200, Robert Morgan wrote:
--
joe speigle
www.sirfsup.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org