On 10/25/07, yogesh <yogesh.arora.daffodil@xxxxxxxxx> wrote: > Hello Frnds, > I am using the Postgres on Linux, its the default that gets > installed with the Suse Linux. > Now when i run the psql command it ask for password....I have created > a role named "abccc" > now i want to assign it a password......how to do it in > Linux......... > > before trying this I was trying to install the Pl/java but it was > giving problem that is > authentication failed for the USer "abccc" if i give the > password ........as i have created the "abccc" role without > password...........by using command > > createuser abbccc. > > If i remove the Password option then it ask that,,,,,,, > Postgres option is not without password(something like this not > exact).......Then i tried to alter the user to set the password for > it.......and face the following problem...... > > > any kind of suggestion would be appreciated ................... http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend