Re: How to know the password for the user 'postgres'

On Mon, Oct 27, 2008 at 10:38 PM, Shashank Sahni <shredder12@gmail.com> wrote:
> 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"

Odd I would have expected it to say something about identd
authentication failing.

Have you tried:

sudo su - postgres
createuser -d -A -P dpsace

?