Обсуждение: initial password
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
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