postgresql下载网址:postgresql下载
一、安裝postgresql
1.創建用戶
# useradd postgres
# passwd postgres
2.解壓安裝
# yum install gcc readline-devel zlib-devel -y
# cd /Data/software/
# tar xzvf postgresql-10.0.tar.gz
# cd postgresql-10
# ./configure --prefix=/usr/local/pgsql10.0
# make -j 10
# make install
安装插件
# export PATH=/usr/local/pgsql/bin/:$PATH
# cd contrib/
# make all
# make install
# ln -sf /usr/local/pgsql10.0 /usr/local/pgsql
3.創建數據庫
# mkdir -p /pgdata02/pgsqldata
# chown -R postgres.postgres /pgdata02/
# su - postgres
-----------------------------------------------------
export PGDATA=/pgdata02/pgsqldata --pgsql不能夠用根目錄存放數據文件等
export PGHOME=/usr/local/pgsql/
export PATH=$PATH:$HOME/bin:$PGHOME/bin
-----------------------------------------------------
$ source .bash_profile
$ initdb
$ pg_ctl start --啓動數據庫
4.設置數據庫開機自啓動
# cp /Data/software/postgresql-10/contrib/start-scripts/linux /etc/init.d/postgresql
# chmod a+x /etc/init.d/postgresql
# vi /etc/init.d/postgresql
-----------------------------------------------------
# Installation prefix
prefix=/usr/local/pgsql
# Data directory
PGDATA="/pgdata02/pgsqldata"
-----------------------------------------------------
# service postgresql restart
# chkconfig postgresql on
5.修改數據庫參數,允許遠程連接
$ vi /pgdata02/pgsqldata/postgresql.conf
-----------------------------------------------------
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)
-----------------------------------------------------
$ vi /pgdata02/pgsqldata/pg_hba.conf
-----------------------------------------------------
# IPv4 local connections:
host all all 0.0.0.0/0 trust
-----------------------------------------------------