gstasica(at)poczta(dot)onet(dot)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