pg 安装文档 - 墨天轮文档

pg 安装文档

王新宇·Harain·จุ๊บ

774

3页

2次

2019-10-31

5墨值下载

（1）创建 postgres 用户

useradd -m -r -s /bin/bash -u 5432 postgres

（2）安装相关依赖包

yum install gettext gcc make perl python perl-ExtUtils-Embed readline-devel

zlib-devel openssl-devel libxml2-devel cmake gcc-c++ libxslt-devel

openldap-devel pam-devel python-devel cyrus-sasl-devel libgcrypt-devel

libgpg-error-devel libstdc++-devel openssl openssl-devel

（3）配置 POSTGRES

下载 postgresql-10.3.tar.gz 到/opt/目录

cd /opt/

tar -xvf postgresql-10.3.tar.gz

cd postgresql-10.3/

./configure --prefix=/opt/postgresql-10.7 --with-segsize=8 --with-wal-segsize=64

--with-wal-blocksize=16 --with-blocksize=16 --with-perl --with-python --with-

openssl --with-libxml --with-libxslt --enable-thread-safety

（4）编译

make && make install

（5）安装

make world && make install -world

（6）创建相关目录及配置环境变量

mkdir -p /data/pgdata/serverlog

mkdir -p /data/pg/data/

chown -R postgres.postgres /data/

su - postgres

vi .bash_profile （删除原来的所有，以下黄色部分直接复制粘贴）

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

# postgres

#PostgreSQL 端口

PGPORT=5432

#PostgreSQL 数据目录

PGDATA=/data/pg/data

export PGPORT PGDATA

#所使用的语言

export LANG=zh_CN.utf8

#PostgreSQL 安装目录

export PGHOME=/opt/postgresql-10.7

#PostgreSQL 连接库文件

export

LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/us

r/local/lib:$LD_LIBRARY_PATH

export DATE=`date +"%Y%m%d%H%M"`

#将 PostgreSQL 的命令行添加到 PATH 环境变量

export PATH=$PGHOME/bin:$PATH

#PostgreSQL 的 man 手册

export MANPATH=$PGHOME/share/man:$MANPATH

#PostgreSQL 的默认用户

export PGUSER=postgres

#PostgreSQL 默认主机地址

export PGHOST=127.0.0.1

#默认的数据库名

export PGDATABASE=postgres

#定义日志存放目录

PGLOG="/data/pgdata/serverlog"

source .bash_profile

（7）初始化数据库

#执行数据库初始化脚本

root 用户登录

chown -R postgres.postgres /data/

su - postgres

$/opt/postgresql-10.7/bin/initdb --encoding=utf8 -D /data/pg/data

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

The database cluster will be initialized with locale "zh_CN.utf8".

initdb: could not find suitable text search configuration for locale

"zh_CN.utf8"

The default text search configuration will be set to "simple".

Data page checksums are disabled.

fixing permissions on existing directory /data/pg/data ... ok

creating subdirectories ... ok

selecting default max_connections ... 100

selecting default shared_buffers ... 128MB

selecting dynamic shared memory implementation ... posix

creating configuration files ... ok

running bootstrap script ... ok

performing post-bootstrap initialization ... ok

syncing data to disk ... ok

WARNING: enabling "trust" authentication for local connections

You can change this by editing pg_hba.conf or using the option -A, or

--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

pg_ctl -D /data/pg/data -l logfile start

================

启动数据库

su - postgres

/opt/postgresql-10.3/bin/pg_ctl -D /data/pg/data -l logfile start

（8）相关命令拷贝

root 用户

mkdir /data/pg/bin

cp /opt/postgresql-10.3/bin/* /data/pg/bin

chown -R postgres.postgres /data/pg/bin

---

更改 PGHOME 目录:

原来:

#PostgreSQL 安装目录

export PGHOME=/opt/postgresql-10.7

改成:

/data/pg

启动数据库

su - postgres

of 3

5墨值下载

postgresql 安装部署

关注

评论