LINUX 下 安装postgresql 10 数据库详解

系统版本：centos 6.5 、postgresql 10

1、安装前置环境

gcc、readline-devel、zlib-devel

gcc介质 https://download.csdn.net/download/qq_25713179/10316034

rpm -Uvh ppl-0.10.2-11.el6.x86_64.rpm cloog-ppl-0.15.7-1.2.el6.x86_64.rpm mpfr-2.4.1-6.el6.x86_64.rpm cpp-4.4.7-18.el6.x86_64.rpm libgcc-4.4.7-18.el6.x86_64.rpm --force --nodeps libgomp-4.4.7-18.el6.x86_64.rpm --force --nodeps gcc-4.4.7-18.el6.x86_64.rpm libstdc++-4.4.7-18.el6.x86_64.rpm --force --nodeps libstdc++-devel-4.4.7-18.el6.x86_64.rpm gcc-c++-4.4.7-18.el6.x86_64.rpm 

readline-devel介质 https://download.csdn.net/download/qq_25713179/10323096

rpm -Uvh readline-devel-6.0-4.el6.x86_64.rpm ncurses-devel-5.7-4.20090207.el6.x86_64.rpm ncurses-libs-5.7-4.20090207.el6.x86_64.rpm ncurses-base-5.7-4.20090207.el6.x86_64.rpm

zlib glibc https://download.csdn.net/download/qq_25713179/10485651

rpm -Uvh glibc-2.12-1.209.el6.x86_64.rpm glibc-common-2.12-1.209.el6.x86_64.rpm glibc-headers-2.12-1.209.el6.x86_64.rpm glibc-devel-2.12-1.209.el6.x86_64.rpm nscd-2.12-1.209.el6.x86_64.rpm tzdata-2016j-1.el6.noarch.rpm zlib-devel-1.2.3-29.el6.x86_64.rpm zlib-1.2.3-29.el6.x86_64.rpm

2、解压postgresql-10.1.tar.gz 到/usr/local/pgsql

3、安装命令 root用户安装

cd /usr/local/pgsql

./configure

make

make install

adduser postgres

mkdir /usr/local/pgsql/data

chown postgres /usr/local/pgsql/data

su - postgres

cd bin

initdb -D /usr/local/pgsql/data

4、优化数据库

修改 /usr/local/pgsql/data下的postgresql.conf 文件 shared_buffers = 2096MB （根据系统内存分配 不超过60%）

5、网内访问设置

允许其他机器链接数据库

修改postgresql.conf 中的 listen_addresses = '*' 

修改pg_hba.conf 

# IPv4 local connections:

host    all             all             0.0.0.0/0   trust

6、启动数据库

cd /usr/local/pgsql/bin

./pg_ctl start -D /usr/local/pgsql/data

7、客户端工具

推荐使用Navicat for PostgreSQL 很方便

http://www.navicat.com.cn/products/navicat-for-postgresql