Difference between revisions of "Postgres"

From Bashlinux
Jump to: navigation, search
(No difference)

Revision as of 20:08, 28 July 2010

PostgreSQL

Setup

  1. Install postgresql packages
 yum install postgresql postgresql-server
  1. Initialize DB 
 mkdir /var/lib/pgsql/data
 chown postgres /var/lib/pgsql/data
 su - postgres
 initdb -D /var/lib/pgsql/data
  1. Start postgres
 pg_ctl -D /usr/local/pgsql/data -l -logfile start
Retrieved from "http://wiki.bashlinux.com/index.php?title=Postgres&oldid=38"