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