| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | adrian(dot)klaver(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, bricklen <bricklen(at)gmail(dot)com> |
| Subject: | Re: Restore |
| Date: | 2010-12-25 02:09:32 |
| Message-ID: | AANLkTi=c4S07EMhF0=uJB23FJxTjb9=5rPUjp3qc07Gv@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
> I didn't copy or paste anything. I just clicked Stop.
No, copy and paste WHAT YOU DID, from your screen into the email. Like this:
smarlowe(at)breckenridge:~$ psql
psql (8.4.5)
Type "help" for help.
smarlowe=# create user joe;
CREATE ROLE
smarlowe=# alter user joe with password='xyz';
ERROR: syntax error at or near "="
LINE 1: alter user joe with password='xyz';
^
smarlowe=# alter user joe with password 'xyz';
ALTER ROLE
smarlowe=# \q
smarlowe(at)breckenridge:~$ psql -U jpe
psql: FATAL: Ident authentication failed for user "jpe"
smarlowe(at)breckenridge:~$ psql -U joe
psql: FATAL: Ident authentication failed for user "joe"
smarlowe(at)breckenridge:~$
So we're not guessing at what you're seeing.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-12-25 02:12:02 | Re: Restore |
| Previous Message | Bob Pawley | 2010-12-25 02:02:19 | Re: Restore |