On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley <rjpawley@shaw.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@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@breckenridge:~$ psql -U jpe
psql: FATAL: Ident authentication failed for user "jpe"
smarlowe@breckenridge:~$ psql -U joe
psql: FATAL: Ident authentication failed for user "joe"
smarlowe@breckenridge:~$
So we're not guessing at what you're seeing.