| From: | Douglas McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: pg_restore |
| Date: | 2007-10-29 17:04:26 |
| Message-ID: | 877il5ua1x.fsf@suzuka.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bob Pawley <rjpawley(at)shaw(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-10-29 17:07:19 | Re: A few questions |
| Previous Message | Samantha Atkins | 2007-10-29 16:52:55 | A few questions |