| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | bricklen <bricklen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore |
| Date: | 2010-12-25 00:57:38 |
| Message-ID: | AANLkTin2YD2+_aAGvoAK_YJf0TRxSk9Q49Ay-tpOpR46@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> I have tried this a number of times -
> psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U &
> postgres and/or < and PDW_June)
>
> Sometimes I am asked for a postgres password, once I was asked for the PDW
> password (this makes sense and which I did enter).
>
> When I entered the password it either said password failed or it simply went
> back to the root command.
Keep in mind, the password set for the unix account is NOT related to
the password set for a user in postgresql with alter user password =
'mypassword';.
If you are entering a unix password for a pg account that hasn't had
the pw set, then it's not going to work. They're not related at all.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2010-12-25 01:00:19 | Re: Restore |
| Previous Message | Adrian Klaver | 2010-12-25 00:27:35 | Re: Restore |