PostgreSQL

From KevinWiki

---

Revision as of 13:35, 10 December 2008

PostgreSQL

PostgreSQL is an object-relational database management system (ORDBMS).

Installation

• Install PostgreSQL

$ sudo apt-get install postgresql 

• Set up the password of the PostgreSQL root user

$ sudo -u postgres psql postgres 

Welcome to psql 8.3.5, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'password'; 
postgres=# \q

• Install pgAdmin III

$ sudo apt-get install pgadmin3