Re: pg_restore - Mailing list pgsql-general

From Douglas McNaught
Subject Re: pg_restore
Date
Msg-id 877il5ua1x.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Re: pg_restore  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Samantha Atkins
Date:
Subject: A few questions
Next
From: David Fetter
Date:
Subject: Re: A few questions