From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Partha Sur" <p(dot)sur(at)worldnet(dot)att(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: createuser problem |
Date: | 2003-09-27 05:41:53 |
Message-ID: | 1586.1064641313@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
"Partha Sur" <p(dot)sur(at)worldnet(dot)att(dot)net> writes:
> -bash-2.05b$ psql -U psur mytest
> psql:FATAL:IDENT authentication failed for user "psur"
Evidently you selected ident authentication in pg_hba.conf. The ident
code is explicitly designed to prevent you from logging in as a Postgres
user name different from your Unix login name --- that is, you surely
can not use -U when using ident auth.
It is possible to get around this with "ident maps" that say which OS
user names are allowed to connect as which Postgres user names. But
I think use of ident maps probably indicates that you haven't thought
through exactly what your security strategy is.
If you are just playing around trying to learn Postgres on a personal
machine, you may as well set your auth method to "trust" and not think
about security. But I counsel revisiting the issue before you go to
production...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Reshat Sabiq | 2003-09-27 19:38:27 | Views and confidentiality |
Previous Message | Oliver Elphick | 2003-09-27 05:26:35 | Re: createuser problem |