Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:
> basicly pg_restore prompts for the password, but no matter what you
> enter it fails, the only way it works is to have
> the server pg_hba.conf file set to trust. version 8.0.0 works, so it
> was the result of some change in versions later than 8.0.0
Hmm. The only relevant-looking change between 8.0.0 and 8.0.1 is
this one:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup_archiver.c.diff?r1=1.101.4.2;r2=1.101.4.3;f=h
I wonder if this could be messing up the password acceptance --- for
instance, by causing CR or LF to not be stripped off what you type.
regards, tom lane