Re: How to know the password for the user 'postgres' - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to know the password for the user 'postgres'
Date
Msg-id dcc563d10810272147u63fa1e0w536e8fbfb2cf03ed@mail.gmail.com
Whole thread Raw
In response to How to know the password for the user 'postgres'  ("Shashank Sahni" <shredder12@gmail.com>)
Responses Re: How to know the password for the user 'postgres'  ("Shashank Sahni" <shredder12@gmail.com>)
List pgsql-general
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

?

pgsql-general by date:

Previous
From: "Shashank Sahni"
Date:
Subject: How to know the password for the user 'postgres'
Next
From: "Shashank Sahni"
Date:
Subject: Re: How to know the password for the user 'postgres'