PostgreSQL运维实战精讲之“postgresql源码安装”

前端之家收集整理的这篇文章主要介绍了PostgreSQL运维实战精讲之“postgresql源码安装”前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

一、下载地址

wget https://ftp.postgresql.org/pub/source/v9.2.4/postgresql-9.2.4.tar.gz


二、安装:

#安装依赖包

yuminstall -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devellibxml2-devel libxslt-devel openldap-devel python-devel gcc-c++ openssl-devel cmake -y

tarzxvf postgresql-9.2.4.tar.gz

cd postgresql-9.2.4

./configure--prefix=/usr/local/pgsql9.2.4 --with-perl --with-python

make

makeinstall


三、安装后的配置

ln-s /usr/local/pgsql9.2.4 /usr/local/pgsql

vim/etc/profile

#addby xuekun 2016-5-11

exportPATH=/usr/local/pgsql/bin:$PATH

exportLD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH

source/etc/profile

#创建数据簇

export PGDATA=/home/osdba/pgdata

[root@localhostosdba]# useradd osdba

[root@localhostosdba]# su osdba

[osdba@localhost~]$ initdb

#安装contrib目录下的工具(root用户下安装)

cd/home/maidong/postgresql-9.2.4

cdcontrib/

make

makeinstall

#启动和停止数据库(osdba用户下)

[osdba@localhostcontrib]$ pg_ctl start -D $PGDATA

[osdba@localhostcontrib]$ pg_ctl stop -D $PGDATA

猜你在找的Postgre SQL相关文章