pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem setting up new users
2+ messages / 2 participants
[nested] [flat]

* Problem setting up new users
@ 2005-05-05 20:17 Michael J. Robinson <robinson@neod.net>
  2005-05-06 03:03 ` Re: Problem setting up new users Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Michael J. Robinson @ 2005-05-05 20:17 UTC (permalink / raw)
  To: pgsql-admin

I'm having problems setting up postgres with new users.  It is a new
install using 7.3..8 rpms.  Use the following to create a new user.

create USER foo WITH PASSWORD 'secret';

When I try to login I get the following error:

[root@host postgressql]# psql template1 -U foo --password
Password: 
psql: FATAL:  IDENT authentication failed for user "foo"

If anyone can help me with this, I would be greatful.

Thank you,

Michael J. Robinson
Northeast Ohio Digital Inc.
http://www.neod.net
robinson@neod.net
330.830.6551
888.232.6363

CONFIDENTIALITY NOTICE: The materials attached hereto are confidential
and the property of the sender. The information contained in the
attached materials is privileged and/or confidential and is intended
only for the use of the above-named individual(s) or entity(ies). If you
are not the intended recipient, be advised that any unauthorized
disclosure, copying, distribution or the taking of any action in
reliance on the contents of the attached information is strictly
prohibited. If you have received this transmission in error, please
discard the information immediately.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Problem setting up new users
  2005-05-05 20:17 Problem setting up new users Michael J. Robinson <robinson@neod.net>
@ 2005-05-06 03:03 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-05-06 03:03 UTC (permalink / raw)
  To: Michael J. Robinson <robinson@neod.net>; +Cc: pgsql-admin

"Michael J. Robinson" <robinson@neod.net> writes:
> When I try to login I get the following error:

> [root@host postgressql]# psql template1 -U foo --password
> Password:
> psql: FATAL:  IDENT authentication failed for user "foo"

The prompt tells the tale: you aren't "foo", you are "root".
IDENT wants those things to be the same.  The password you
forced psql to ask you for is totally irrelevant.

Probably your best bet is to "su" from root to postgres and then create
your initial users as postgres.  You can create root as a postgres
superuser if you would prefer to do this sort of maintenance from the
root account in future.  (Whether that's a good idea is another question
--- in general, using root for more than you absolutely must isn't good
practice IMHO.)

You could also think about changing to some other auth method besides
IDENT, if you would prefer to operate with Postgres passwords instead of
who-are-you-to-the-kernel.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-06 03:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-05 20:17 Problem setting up new users Michael J. Robinson <robinson@neod.net>
2005-05-06 03:03 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox