Skip site navigation (1) Skip section navigation (2)

Re: initial password

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Steve CrawfordDate: 2010-07-16 15:47:59
Subject: Re: Need help doing a CSV import
Previous:From: lee cDate: 2010-07-16 03:54:54
Subject: initial password

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group