##PostgressQL
Reference: PostgreSQL Yum Installation
-
edit /etc/yum.repos.d/CentOS-Base.repo,
[base]
and[updates]
sections, addexclude=postgresql*
-
download PGDG RPM
curl -O http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-centos92-9.2-6.noarch.rpm
-
install RPM distribution
sudo rpm -ivh pgdg-centos92-9.2-6.noarch.rpm
-
install PostgreSQL 9.1 server:
sudo yum install postgresql92-server
-
initialize and start the database
sudo service postgresql-9.2 initdb sudo service postgresql-9.2 start
-
edit /var/lib/pgsql/9.2/data/pg_ident.conf, change
ident
tomd5
-
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
-
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