From: | "Shashank Sahni" <shredder12(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How to know the password for the user 'postgres' |
Date: | 2008-10-28 04:38:33 |
Message-ID: | c75227c70810272138w3f6b364bq88c17477f699aa93@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello people,
I was trying to install dspace on my computer and it
required postgresql as a prerequisite. Since I am using Ubuntu so i just
downloaded and installed it using synaptic package manager. For the
installation of dspace i was supposed to exeucte the following
command..
createuser -U postgres -d -A -P dspace
but whenever i execute it, it asks for password for the new role and then
after giving the password..it says..
createuser: could not connect to database postgres: FATAL: password
authentication failed for user "postgres"
when i posted the question on dspace mailing list..one of the guy replied me
with this solution..
createuser -h localhost -U postgres -d -A -P dspace
but he said that to execute the above command i must know the password for
the user postgres..
on running this command at the end i was prompted to the enter the password
for the user postgres but i don't know the password..I think this user was
created as default at the time postgresql was installed..then there must be
a default password ...
Please help me with this problem..
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-10-28 04:47:54 | Re: How to know the password for the user 'postgres' |
Previous Message | Abdul Rahman | 2008-10-28 04:05:22 | Re: Replication with slony-I |