看到有个大佬写了个很实用的脚本,于是这里做了转载
#!/bin/bash #进入软件的制定安装目录 echo "进入目录/usr/local,下载pgsql文件" cd /usr/local #判断是否有postgre版本的安装包 if [ -d post* ] then rm -rf /usr/local/post* echo "安装包删除成功" fi #开始下载pgsql版本10.5并解压 if [ ! -d /usr/local/src ] then mkdir /usr/local/src fi cd /usr/local/src wget https://ftp.postgresql.org/pub/source/v10.5/postgresql-10.5.tar.gz if [ $? == 0 ] then tar -zxf postgresql-10.5.tar.gz -C /usr/local/ fi echo "pgsql文件解压成功" #判断用户是否存在 id $postgres >& /dev/null echo "用户postgres已存在" if [ $? -ne 0 ] then echo "用户不存在,开始创建postgres用户" groupadd postgres useradd -g postgres postgres fi echo "重命名postgresql并且进入安装目录" mv /usr/local/post* /usr/local/pgsql cd /usr/local/pgsql #-------------------------------安装pgsql------------------------------------ echo "安装一些库文件" yum install -y zlib zlib-devel >& /del/null echo "开始执行configure步骤" ./configure --prefix=/usr/local/pgsql --without-readline if [ $? == 0 ] then echo "configure配置通过,开始进行make编译" make if [ $? == 0 ] then echo "make编译通过,开始进行make install安装步骤" make install if [ $? != 0 ];then echo "make install安装失败" fi echo "安装成功" else echo "make编译失败,检查错误。" fi else echo "configure检查配置失败,请查看错误进行安装库文件" fi echo "开始进行pgsql的配置" echo "给pgsql创建data目录" mkdir -p /usr/local/pgsql/data echo "修改用户组" chown -R postgres:postgres /usr/local/pgsql echo "添加环境变量,进入postgres用户的家目录" cd /home/postgres if [ -f .bash_profile ] ;then cp .bash_profile .bash_profile.bak echo "export PGHOME=/usr/local/pgsql" >> .bash_profile echo "export PGDATA=/usr/local/pgsql/data" >> .bash_profile echo "PATH=$PGHOME/bin:$PATH" >> .bash_profile echo "MANPATH=$PGHOME/share/man:$MANPATH" >> .bash_profile echo "LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH" >> .bash_profile fi alias pg_start='pg_ctl -D $PGDATA -l /usr/local/pgsql/logfile start' alias ps_stop='pg_ctl -D $PGDATA -l /usr/local/pgsql/logfile stop' echo "切换至postgres用户来初始化数据库" su - postgres -c "/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data" echo "---------------------------------------------------------------------------------------" echo "---------------------------------------------------------------------------------------" echo "----------------------------SUCCESS INSTALLATION OF POSTGRESQL-------------------------"