password for postgres

From: Kusuma Pabba <kusumap(at)ncoretech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: password for postgres
Date: 2009-02-13 10:18:32
Message-ID: 499548F8.4000803@ncoretech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i don't know y am i getting this problem

when i try to start off postgres
it asks me for password:

i did not set any password as such

except that when the first day i used template, i ahve used the below
two statements
ALTER USER postgres with encrypted password 'your_password';
ALTER USER postgres with encrypted password 'welcome';

but it is not accepting both the passwords
i am getting incorrect password after three trials it is returning back
to command prompt

when i have used
select * from pg_shadow;
then i got

md5d31faa0b92fad4e2d8e4af34a30f890b

though i use this i am not able to acess i don't know what to do with
this issue
can any one shed light on me by explaining me what was the mistake i did
or which password to use
thanks for any help

Regards
kusuma.p

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2009-02-13 11:22:52 Re: password for postgres
Previous Message Ivan Sergio Borgonovo 2009-02-13 09:22:01 Re: TSearch queries with multiple languages