Thread: initial password

initial password

From

lee c

Date:

16 July 2010, 15:31:41

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

Re: initial password

From

Thom Brown

Date:

16 July 2010, 15:37:08

On 16 July 2010 04:54, lee c <lcat45@gmail.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