pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan'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>
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 12:56 Gaetano Mendola <mendola@bigfoot.com>
parent: Greg <gstasica@poczta.onet.pl>
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-31 04:24 Tom Lane <tgl@sss.pgh.pa.us>
parent: Greg <gstasica@poczta.onet.pl>
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