Installing Postgres on Ubuntu

1. Installing postres
[code lang="shell"]
sudo apt-get install postgresql postgresql-client postgresql-contrib
[/code]
2. Postres database password change
[code lang="shell"]
sudo su postgres -c psql
postgres=# ALTER USER postgres WITH PASSWORD 'newPassword';
postgres=# q
[code]
3. Remove password for user on ubuntu
[code lang="shell"]
sudo passwd -d postgres
[/code]
4. Add password for user
[code lang="shell"][/code]
sudo su postgres -c passwd
[code][/code]

Komentarze

Popularne posty z tego bloga

Set up JBoss AS 5.1.0 and Seam 2.2.0 in Ubuntu 9.04