Re: initial password

On 16 July 2010 04:54, lee c <lcat45(at)gmail(dot)com> wrote:
> Just installed on Ubuntu 10.04 and want to connect to a database but don't
> know the master password for postgre or how to what to do to get around
> this.....any help appreciated....have tried to install on other versions of
> Ubuntu and have always had the same problem
>

By default, the postgres user doesn't have a password. It's not
generally advised to set a password for that user, but to instead set
up a user to log in as. To do this, you'll need to become the
postgres user like so:

sudo su
<enter password>
su postgres
psql

That will get you connected to Postgres from which you can create your new role.

Alternatively, while the postgres user, try using createuser.

Regards

Thom