| From: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | FATAL Authentication |
| Date: | 2008-06-04 20:29:09 |
| Message-ID: | B0D7C0A3F35FE144A70312D086CBCA9B0509A42F@ExchMailbox2.univ.dir.wwu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)dev tmp]$ createdb -U postgres lan_portal
createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "postgres"
[root(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-06-04 20:42:29 | Re: FATAL Authentication |
| Previous Message | Oleg Bartunov | 2008-06-04 19:51:48 | Re: tsearch2 dictionary for statute cites |