Re: Restore

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.