pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

FATAL Authentication
2+ messages / 2 participants
[nested] [flat]

* FATAL Authentication
@ 2008-06-04 20:29 Marc Fromm <Marc.Fromm@wwu.edu>
  2008-06-04 20:42 ` Re: FATAL Authentication Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Marc Fromm @ 2008-06-04 20:29 UTC (permalink / raw)
  To: pgsql-admin

I am trying to run commands from the shell (without becoming the postgres user first), which work fine on our live server, but on our dev server I receive FATAL authentication errors.

[root@dev tmp]$ createdb -U postgres lan_portal
createdb: could not connect to database postgres: FATAL:  Ident authentication failed for user "postgres"

[root@dev tmp]$ psql -U postgres lan_portal < /tmp/lan_portal.bck
psql: FATAL:  Ident authentication failed for user "postgres"

What needs to be configured so I can run the above commands in the shell?

I was able to create the database once I "su" to postgres, using CREATE DATABASE, but I do not know how to restore a database as I do in the shell as listed above.

Thanks

Marc




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

* Re: FATAL Authentication
  2008-06-04 20:29 FATAL Authentication Marc Fromm <Marc.Fromm@wwu.edu>
@ 2008-06-04 20:42 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-06-04 20:42 UTC (permalink / raw)
  To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin

Marc Fromm <Marc.Fromm@wwu.edu> writes:
> I am trying to run commands from the shell (without becoming the postgres user first), which work fine on our live server, but on our dev server I receive FATAL authentication errors.
> [root@dev tmp]$ createdb -U postgres lan_portal
> createdb: could not connect to database postgres: FATAL:  Ident authentication failed for user "postgres"

The -U option is just about entirely useless under "ident sameuser"
authentication, which apparently is what you are using.  If you like
ident auth in general, you can make it do what you want by setting
up a map file that lets (eg) root become any of a list of postgres
user names.  Or you could switch to some other auth method.  See
http://www.postgresql.org/docs/8.3/static/client-authentication.html

			regards, tom lane



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

end of thread, other threads:[~2008-06-04 20:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-04 20:29 FATAL Authentication Marc Fromm <Marc.Fromm@wwu.edu>
2008-06-04 20:42 ` 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