PostgreSQL 安装

sudo apt-get install postgresql-9.1

out put :)

 

Installation Finished. :)

Please read the official reference about how to use PostgreSQL

http://www.postgresql.org/docs/9.1/interactive/tutorial-createdb.html

 

____________

su root
su - postgres
#log into postgres

psql -U posgres

 

then we get into the postgreSQL console

postgres# ALTER USER postgres with password 'shift';
ALTER ROLE
postgres# ALTER ROLE postgres=# \q
exit
root@universe#

then we get out of the database console.

restart the postgresql service

sudo service postgresql --restart

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

many things about postgresql 's role system

http://www.postgresql.org/docs/9.1/interactive/database-roles.html

 

comparing to mysql ==> such a easy one! Imean MySQL.