pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can't restore from pg_dump. Authentication failed
3+ messages / 3 participants
[nested] [flat]

* Can't restore from pg_dump. Authentication failed
@ 2004-05-26 11:08 Greg <gstasica@poczta.onet.pl>
  2004-05-26 12:56 ` Re: Can't restore from pg_dump. Authentication failed Gaetano Mendola <mendola@bigfoot.com>
  2004-05-31 04:24 ` Re: Can't restore from pg_dump. Authentication failed Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: gstasica@poczta.onet.pl @ 2004-05-26 11:08 UTC (permalink / raw)
  To: pgsql-admin

Hi,

Frankly I don't know what should I do more. The problem is:
I've made a pg_dump from shell like that:
pg_dump -Upostgres -O -D -Fc --file=baza.sql

Copied the file to new server and from shell executed:
linux:~ # pg_restore -d ppr -U postgres -i baza.sql
The result is
pg_restore: [archiver (db)] connection to database "ppr" failed:
FATAL:  IDENT authentication failed for user "postgres"

I don't know what is going on since I can login to ppr database like
that
(in shell)
su - postgres
psql -dppr

Could anybody help me.



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

* Re: Can't restore from pg_dump. Authentication failed
  2004-05-26 11:08 Can't restore from pg_dump. Authentication failed Greg <gstasica@poczta.onet.pl>
@ 2004-05-26 12:56 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Gaetano Mendola @ 2004-05-26 12:56 UTC (permalink / raw)
  To: Greg <gstasica@poczta.onet.pl>

Greg wrote:

> Hi,
> 
> Frankly I don't know what should I do more. The problem is:
> I've made a pg_dump from shell like that:
> pg_dump -Upostgres -O -D -Fc --file=baza.sql
> 
> Copied the file to new server and from shell executed:
> linux:~ # pg_restore -d ppr -U postgres -i baza.sql
> The result is
> pg_restore: [archiver (db)] connection to database "ppr" failed:
> FATAL:  IDENT authentication failed for user "postgres"
> 
> I don't know what is going on since I can login to ppr database like
> that
> (in shell)
> su - postgres
> psql -dppr

try in this way:

su - postgres
psql -f baza.sql dppr


Regards
Gaetano Mendola







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

* Re: Can't restore from pg_dump. Authentication failed
  2004-05-26 11:08 Can't restore from pg_dump. Authentication failed Greg <gstasica@poczta.onet.pl>
@ 2004-05-31 04:24 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-05-31 04:24 UTC (permalink / raw)
  To: gstasica@poczta.onet.pl; +Cc: pgsql-admin

gstasica@poczta.onet.pl (Greg) writes:
> linux:~ # pg_restore -d ppr -U postgres -i baza.sql
> pg_restore: [archiver (db)] connection to database "ppr" failed:
> FATAL:  IDENT authentication failed for user "postgres"

You can't use "-U" or similar switches when you've selected IDENT
authentication --- the whole point of that auth method is that your
Postgres userid must be the same as your logged-in Unix userid.

If this is not what you want, select another auth method in
pg_hba.conf.

Or if you want to get tricky, you can play around with an ident
map file.  See the documentation.

			regards, tom lane



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


end of thread, other threads:[~2004-05-31 04:24 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-26 11:08 Can't restore from pg_dump. Authentication failed Greg <gstasica@poczta.onet.pl>
2004-05-26 12:56 ` Gaetano Mendola <mendola@bigfoot.com>
2004-05-31 04:24 ` 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