CODEWITHSUNDEEP
postgresqlubuntu-10.10
thesteve
thesteve

Reputation: 2503

Resetting 'postgres' user password in Postgresql 8.4 on Ubuntu10.10

I am attempting a postgresql tutorial and cannot login to the 'postgres' user account which seems to be necessary to perform any actions. When I went through the installation I thought I wrote down the password but apparently not. Is there a way for me to reset the password or do I need to reinstall? Thanks for any advice.

Upvotes: 3

Views: 6850

Answers (1)

Kromey
Kromey

Reputation: 1212

sudo passwd postgres will let you do it.

Alternatively, sudo su - postgres will let you log in to the postgres user's account without the password at all (you'll be asked for your password to use sudo, naturally).

Upvotes: 14

Related Questions