петък, 16 май 2008 г.

Postgres и Ubuntu



sudo apt-get install postgresql-8.2 postgresql-client-8.2 postgresql-contrib-8.2
sudo apt-get install pgadmin3
root# su - postgres
psql template1

template1=# ALTER USER postgres WITH PASSWORD ‘password’;
template1=# \q (\l list of databases)

postgres@stanley-laptop:~$ su
Password:
root@stanley-laptop:/var/lib/postgresql# passwd -d postgres
Password changed.

root@stanley-laptop:/var/lib/postgresql# su postgres -c passwd
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully

1 коментар:

Stefan каза...

http://fullcirclemagazine.org/ - The FREE Independent Magazine (and podcast) for the Ubuntu Linux Community