PostgreSQL on CentOS6

gistfile1.md

##PostgressQL

Reference: PostgreSQL Yum Installation

1. edit /etc/yum.repos.d/CentOS-Base.repo, [base] and [updates] sections, add

    exclude=postgresql*
   

2. download PGDG RPM

    curl -O http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-6.noarch.rpm
   

3. install RPM distribution

    sudo rpm -ivh pgdg-centos92-9.2-6.noarch.rpm
   

4. install PostgreSQL 9.1 server:

    sudo yum install postgresql92-server
   

5. initialize and start the database

    sudo service postgresql-9.2 initdb
    sudo service postgresql-9.2 start
   

6. edit /var/lib/pgsql/9.2/data/pg_ident.conf, change ident to md5

7. automatically launched when the OS starts

    sudo chkconfig postgresql-9.2 on
   

##plv8js ###V8 Engine Javascript Procedural Language add-on for PostgreSQL

• Require:

    1. postgresql
    2. v8 engine
  

• install v8

    mkdir ~/build
    cd ~/build
    svn checkout http://v8.googlecode.com/svn/trunk/ v8
    cd v8
    export GYPFLAGS="-D OS=freebsd"
    make dependencies
    make native.check -j 4 library=shared strictaliasing=off console=readline