Difference between revisions of "Postgres"

From Bashlinux
Jump to: navigation, search
 
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
=PostgreSQL=
+
= PostgreSQL =
 
== Setup ==
 
== Setup ==
 
# Install postgresql packages
 
# Install postgresql packages

Revision as of 20:09, 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