目录:
搭建过程
-
安装PG
[root@localhost ~]# yum install readline* -y [root@localhost ~]# wget https://ftp.postgresql.org/pub/source/v9.5.1/postgresql-9.5.1.tar.gz [root@localhost ~]# tar xvf postgresql-9.5.1.tar.gz [root@localhost ~]# cd postgresql-9.5.1/ [root@localhost postgresql-9.5.1]# ./configure --prefix=/usr/local/pgsql --without-zlib [root@localhost postgresql-9.5.1]# make world && make install-world
-
创建用户及用户组
[root@localhost postgresql-9.5.1]# groupadd -g 101 dba [root@localhost postgresql-9.5.1]# useradd -u 516 -g dba -G root -d /usr/local/pgsql postgres [root@localhost postgresql-9.5.1]# id postgres uid=516(postgres) gid=101(dba) groups=101(dba),0(root) [root@localhost postgresql-9.5.1]# passwd postgres
-
配置.bash_profile
[root@localhost ~]# cp /etc/skel/.* /usr/local/pgsql/ [root@localhost skel]# cd /usr/local/pgsql/ [root@localhost pgsql]# vim .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PGHOME=/usr/local/pgsql export PGDATA=/usr/local/pgsql/data export PATH=$PATH:/usr/local/pgsql/bin #stty erase ^H set umask to 022 umask 022 PS1