Postgres

From Bashlinux
Revision as of 20:08, 28 July 2010 by Manpaz (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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"