PostgreSQL

From KevinWiki

Revision as of 13:35, 10 December 2008 by Kevin (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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
Retrieved from "http://kevinlee.io/wiki/PostgreSQL"
Personal tools