PostgreSQL深入浅出 | CentOS7.9安装PG12

1、目录规划

介质目录: /root 程序目录: /usr/local/pgsql 数据目录: /usr/local/pgsql/pgdata 日志目录: /usr/local/pgsql/pglog 归档目录: /usr/local/pgsql/archive

2、创建相关目录

mkdir -p /usr/local/pgsql mkdir -p /usr/local/pgsql/pgdata mkdir -p /usr/local/pgsql/pglog mkdir -p /usr/local/pgsql/pgarch

PostgreSQL深入浅出 | CentOS7.9安装PG12

3、创建Postgres用户

useradd -u 2000 postgres echo postgres | passwd --stdin postgres

PostgreSQL深入浅出 | CentOS7.9安装PG12

4、解压安装介质

cd ~ tar zxf postgresql-12.12.tar.gz -C /usr/local/pgsql

PostgreSQL深入浅出 | CentOS7.9安装PG12

5、配置YUM仓库

挂载系统介质并配置yum 确保虚拟机光驱是连接状态

mount /dev/sr0 /mnt

PostgreSQL深入浅出 | CentOS7.9安装PG12

备份当前yum

cd /etc/yum.repos.d/ mkdir bak mv *.repo bak/

编辑repo配置文件,加入如下内容

cat > /etc/yum.repos.d/local.repo /home/postgres/.bashrc