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: (view raw, whole thread or download thread mbox)
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

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

Alternatively, while the postgres user, try using createuser.



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-2017 The PostgreSQL Global Development Group