Re: pg_restore

Bob Pawley <rjpawley@shaw.ca> writes:

> Following the examples in the docs I've come to this.
>
> I am attempting to restore the existing sql dump using
> psql -d PDW -f aurel.sql
>
> I am then asked for a password.
>
> I try every password that the computer knows with no success.
>
> Funny thing the password cursor doesn't move when inputting the password.

This is standard for Unix command-line applications.

> I keep getting authentication failure.
>
> When I attempt to do a new pg_dump with -Fc I also get a request for
> password with identical results.

Sounds like you need to fix pg_hba.conf then.

-Doug