title: Set password in PostgreSQL
body: <p>I am trying to set new password in postgreSQL.But I am getting error like below.<code>
  [root@localhost ~]# sudo -u postgres psql</code></p>
  
  <pre><code> could not change directory to "/root"
   Welcome to psql 8.1.23, 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`postgres=# \password postgres
    Query buffer is empty.
    \p: extra argument "assword" ignored
    \p: extra argument "postgres" ignored`
  </code></pre>