Re: [ADMIN] Can't restore from pg_dump. Authentication failed

2004-05-30 Thread Tom Lane
[EMAIL PROTECTED] (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 --- t

[ADMIN] Can't restore from pg_dump. Authentication failed

2004-05-30 Thread Greg
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

Re: [ADMIN] Can't restore from pg_dump. Authentication failed

2004-05-26 Thread Gaetano Mendola
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: [ar