Skip to content

Instantly share code, notes, and snippets.

@xiocode
Last active December 27, 2015 13:19
Show Gist options
  • Save xiocode/7332027 to your computer and use it in GitHub Desktop.
Save xiocode/7332027 to your computer and use it in GitHub Desktop.
install postgresql 9.3.1 on centos 6
wget http://ftp.postgresql.org/pub/source/v9.3.1/postgresql-9.3.1.tar.gz
tar -xvf postgresql-9.3.1.tar.gz
yum install readline-devel zlib-devel gcc
cd postgresql-9.3.1
./configure
make && make install
@xiocode
Copy link
Author

xiocode commented Nov 6, 2013

/sbin/ldconfig /usr/local/pgsql/lib

@xiocode
Copy link
Author

xiocode commented Nov 6, 2013

adduser postgres

@xiocode
Copy link
Author

xiocode commented Nov 6, 2013

su - postgres

mkdir data

/usr/local/pgsql/bin/initdb -D /home/postgres/data/

@xiocode
Copy link
Author

xiocode commented Nov 6, 2013

postgres.conf

listen_addresses = '*'

fsync=off
synchronous_commit=off
full_page_writes=off
bgwriter_lru_maxpages=0

@xiocode
Copy link
Author

xiocode commented Nov 6, 2013

pg_hba.conf

host all all 0.0.0.0/0 md5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment