Hi, I am trying to find out limitation on what symbols can be used in password option.
Example below attempts fail. Does not allow to alter password if it starts with '!' ----------------------------------------------------- -bash-3.2$ psql -Upostgres -q -c "alter user gopal with password '!123'" -bash: !123: event not found Allows us to alter password, but fails while authentication. ------------------------------------------------------------ -bash-3.2$ psql -Upostgres -q -c "alter user gopal with password '$123'" -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" -bash-3.2$ psql -Upostgres -q -c "alter user gopal with password '$abc'" -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" If we use/script tries to use environment variables like $PWD or $PATH. It basically expands the ENV variable and its value is stored. ---------------------------------------------------------------------- -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" -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. Thanks SureshA -----Original Message----- From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com] Sent: Wednesday, November 11, 2009 2:46 PM To: suresh adapa Cc: pgsql-bugs@postgresql.org Subject: Re: FW: [BUGS] postgresql-8.3.6-1PGDG : password suresh adapa wrote: > 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. I don't understand what you were trying to do and if you think there's something wrong there.. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
