From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | lee c <lcat45(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: initial password |
Date: | 2010-07-16 15:36:38 |
Message-ID: | AANLkTikEkLwg8v9utD3jx8jM5Mis9uieX_fkcfsZpCgM@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2010-07-16 15:47:59 | Re: Need help doing a CSV import |
Previous Message | lee c | 2010-07-16 03:54:54 | initial password |