Postgresql on Ubuntu
Thursday, 24. September 2009, 19:23:50
I just installed Postgresql on my Ubuntu 9.04 jaunty and after it completes I tried to login with PgAdmin when I realized that I haven't set a password for postgres user.
I found a couple of steps to get it, but man, it's silly that the user must know these details.
first, reset your postgres password
$ sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD 'password';
template1=# \q
then, set the system's user postgres password
$ sudo passwd -d postgres
$ sudo su postgres -c passwd
if you want more details, this post is worth to read
http://hocuspokus.net/2008/05/install-postgresql-on-ubuntu-804
I found a couple of steps to get it, but man, it's silly that the user must know these details.
first, reset your postgres password
$ sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD 'password';
template1=# \q
then, set the system's user postgres password
$ sudo passwd -d postgres
$ sudo su postgres -c passwd
if you want more details, this post is worth to read
http://hocuspokus.net/2008/05/install-postgresql-on-ubuntu-804
WIDGETIZE
How to use Quote function: