On Fri, Dec 24, 2010 at 7:02 PM, Bob Pawley <rjpaw...@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:
smarl...@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
smarl...@breckenridge:~$ psql -U jpe
psql: FATAL: Ident authentication failed for user "jpe"
smarl...@breckenridge:~$ psql -U joe
psql: FATAL: Ident authentication failed for user "joe"
smarl...@breckenridge:~$
So we're not guessing at what you're seeing.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
