创建目录
mkdir -p /usr/local/pg10
ln -s /usr/local/pg10 /usr/local/pgsql
chown -R postgres.postgres /user/local/pgsql
编译安装
./configure --prefix=/usr/local/pgsql
make
make install
新建postgres用户与数据库的数据目录
useradd postgres
su - postgres
mkdir /usr/local/pgsql/data
chmod 700 /usr/local/pgsql/data
创建数据库集群
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
或者
/usr/local/pgsql/bin/pg_ctl initdb -D /usr/local/pgsql/data
启停数据库
- 启动数据库
/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data - 停止数据库
/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data -m fast - 重启数据库
/usr/local/pgsql/bin/pg_ctl restart -D /usr/local/pgsql/data -m fast - 重新载入数据库配置文件
/usr/local/pgsql/bin/pg_ctl reload -D /usr/local/pgsql/data
注意
为了方便,可以设置环境变量PGDATA
export PGDATA=/usr/local/pgsql/data
export PATH=/usr/local/pgsql/bin
pg_ctl start
pg_ctl stop -m fast
pg_ctl reload
。。。