Re: FW: postgresql-8.3.6-1PGDG : password

Hi,

I am basically testing few things as below for one off my Task
requirement.
Can you please check below Test Case 4,6 and 7 and comment.

Test Case 1)
createuser -P -S --createdb --no-createrole suresha
Suresh&12
createdb -E UTF8 -O suresha TEST

Test Case 2)
createuser -P -S --createdb --no-createrole adapa
@-&)(*^#!
createdb -E UTF8 -O adapa TEST2

Test Case 3)
-bash-3.2$ psql -Upostgres -q -c "alter user gopal with password
'&gopal'"
-bash-3.2$ psql -h 127.0.0.1 -U gopal -d TEST3
Password for user gopal:
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

TEST3=> \q

Test Case 4)
-bash-3.2$ psql -Upostgres -q -c "alter user gopal with password
'$gopal'"
-bash-3.2$ psql -h 127.0.0.1 -U gopal -d TEST3
Password for user gopal:
psql: FATAL: password authentication failed for user "gopal"

Test Case 5)
-bash-3.2$ pwd
/var/lib/pgsql
-bash-3.2$ psql -Upostgres -q -c "alter user gopal with password $PWD"
ERROR: syntax error at or near "/"
LINE 1: alter user gopal with password /var/lib/pgsql

Test Case 6)
-bash-3.2$ pwd
/var/lib/pgsql
-bash-3.2$ psql -Upostgres -q -c "alter user gopal with password '$PWD'"
-bash-3.2$ psql -h 127.0.0.1 -U gopal -d TEST3
Password for user gopal: $PWD
psql: FATAL: password authentication failed for user "gopal"

Test Case 7)
-bash-3.2$ pwd
/var/lib/pgsql
-bash-3.2$ psql -h 127.0.0.1 -U gopal -d TEST3
Password for user gopal: /var/lib/pgsql
Welcome to psql 8.3.6, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

TEST3=> \q

Thanks
SureshA

-----Original Message-----
From: Heikki Linnakangas [mailto:heikki(dot)linnakangas(at)enterprisedb(dot)com]
Sent: Wednesday, November 11, 2009 1:19 PM
To: suresh adapa
Subject: Re: FW: [BUGS] postgresql-8.3.6-1PGDG : password

suresh adapa wrote:
> I have a quick question. Is there any limitation on the type of
> characters I use for postgresql8.36-1PGDG database password?

Hmm, I don't think so. Better stick to ASCII-characters, though. During
the authentication phase, you haven't yet connected to any database, so
it's not clear which encoding is used for the password. If you only use
one encoding across the board, it should still work, but otherwise you
can end up confused.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com