Postgresql 9.5.3 설치

#yum -y install gcc gcc-c++ boost boost-devel pkgconfig uuidd libtool autoconf make coreutils uuid-dev uuid-devel libuuid-devel e2fsprogs-devel readline readline-devel zlib zlib-devel openssl openssl-devel gettext

#cd /usr/local/src

#wget https://ftp.postgresql.org/pub/source/v9.5.3/postgresql-9.5.3.tar.gz

#tar zxvf postgresql-9.5.3.tar.gz

#cd postgresql-9.5.3

#./configure –prefix=/usr/local/pgsql –enable-depend –enable-nls=ko –with-openssl

#make && make install

#ln -s /usr/local/pgsql/bin/psql /usr/bin/psql
#ln -s /usr/local/pgsql/bin/dropdb /usr/bin/dropdb
#ln -s /usr/local/pgsql/bin/dropuser /usr/bin/dropuser
#ln -s /usr/local/pgsql/bin/createuser /usr/bin/createuser
#ln -s /usr/local/pgsql/bin/createdb /usr/bin/createdb

#useradd postgres
#chown -R postgres:postgres /usr/local/pgsql

#mkdir –parents /usr/local/pgsql/data
#chown -R postgres:postgres /usr/local/pgsql/data

vi /etc/sudoers

## The COMMANDS section may have other options added to it.
##
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
postgres ALL=(ALL) NOPASSWD: NOPASSWD: ALL   // 내용 추가

#su – postgres
#/usr/local/pgsql/bin/initdb -E UTF-8 –locale=ko_KR.UTF-8 –lc-collate=C -D /usr/local/pgsql/data

# Start foreground running
sudo -u postgres /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

# Start background running
sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

# Stop
sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop

vi start.sh
#!/bin/bash
sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

vi stop.sh
#!/bin/bash
sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop

# chmod 755 start.sh stop.sh

# su – postgres
$ /usr/local/pgsql/bin/createdb test
$ psql test
test=#