centos8 安装postgre

woshilys

已于 2024-03-12 15:23:27 修改

阅读量470

点赞数 7

分类专栏： pg 文章标签： postgre

于 2024-01-26 11:57:01 首次发布

本文链接：https://blog.csdn.net/woshilys/article/details/135862714

版权

pg 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

安装依赖包

yum install -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel openldap-devel  gcc-c++ openssl-devel cmake


yum search python|grep devel
上次元数据过期检查：2:24:27 前，执行于 2024年01月26日 星期五 09时14分59秒。
platform-python-devel.i686 : Libraries and header files needed for Python development
platform-python-devel.x86_64 : Libraries and header files needed for Python development
python2-devel.x86_64 : Libraries and header files needed for Python 2 development
python2-tools.x86_64 : A collection of development tools included with Python 2
python3-idle.i686 : A basic graphical development environment for Python
python3-idle.x86_64 : A basic graphical development environment for Python
python3-werkzeug.noarch : The Swiss Army knife of Python web development
python36-devel.x86_64 : Libraries and header files needed for Python development
python38-devel.x86_64 : Libraries and header files needed for Python development
python38-idle.x86_64 : A basic graphical development environment for Python
python39-devel.x86_64 : Libraries and header files needed for Python development
python39-idle.x86_64 : A basic graphical development environment for Python
python2-cairo-devel.x86_64 : Libraries and headers for py2cairo
[root@localhost ~]# yum  install python36-devel.x86_64
上次元数据过期检查：2:24:57 前，执行于 2024年01月26日 星期五 09时14分59秒。
依赖关系解决。
========================================================================================================================
 软件包                          架构            版本                                          仓库                大小
========================================================================================================================
安装:
 python36-devel                  x86_64          3.6.8-38.module_el8.5.0+895+a459eca8          AppStream           16 k
安装依赖关系:
 platform-python-devel           x86_64          3.6.8-41.el8                                  AppStream          249 k
 python3-rpm-generators          noarch          5-7.el8                                       AppStream           25 k

事务概要
========================================================================================================================
安装  3 软件包

总下载：291 k
安装大小：767 k
确定吗？[y/N]： y
下载软件包：
(1/3): python3-rpm-generators-5-7.el8.noarch.rpm                                        166 kB/s |  25 kB     00:00    
(2/3): python36-devel-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64.rpm                   104 kB/s |  16 kB     00:00    
(3/3): platform-python-devel-3.6.8-41.el8.x86_64.rpm                                    881 kB/s | 249 kB     00:00    
------------------------------------------------------------------------------------------------------------------------
总计                                                                                    1.0 MB/s | 291 kB     00:00     
运行事务检查
事务检查成功。
运行事务测试
事务测试成功。
运行事务
  准备中  :                                                                                                         1/1 
  安装    : python3-rpm-generators-5-7.el8.noarch                                                                   1/3 
  安装    : platform-python-devel-3.6.8-41.el8.x86_64                                                               2/3 
  安装    : python36-devel-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64                                              3/3 
  运行脚本: python36-devel-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64                                              3/3 
  验证    : platform-python-devel-3.6.8-41.el8.x86_64                                                               1/3 
  验证    : python3-rpm-generators-5-7.el8.noarch                                                                   2/3 
  验证    : python36-devel-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64                                              3/3 

已安装:
  platform-python-devel-3.6.8-41.el8.x86_64                             python3-rpm-generators-5-7.el8.noarch           
  python36-devel-3.6.8-38.module_el8.5.0+895+a459eca8.x86_64           

完毕！

安装


 
 

./configure --prefix=/opt/pgsql --with-perl --with-python

make  

make install

创建目录


groupadd postgres
useradd -g postgres   postgres

id postgres

chown -R postgres:postgres  /opt/pgsql

[root@localhost pgsql]# ll
总用量 16
drwxr-xr-x. 2 postgres postgres 4096 1月  26 11:46 bin
drwxr-xr-x. 2 postgres postgres    6 1月  25 17:15 data
drwxr-xr-x. 6 postgres postgres 4096 1月  26 11:46 include
drwxr-xr-x. 4 postgres postgres 4096 1月  26 11:46 lib
drwxr-xr-x. 6 postgres postgres 4096 1月  26 11:46 share
[root@localhost pgsql]#

配置环境变量


vi .bash_profile

export PGHOME=/opt/pgsql
 
export PGDATA=/opt/pgsql/data
 
PATH=$PATH:$HOME/bin:$PGHOME/bin

保存，退出vi。执行以下命令，使环境变量生效

  source .bash_profile 

[postgres@localhost ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi


export PGHOME=/opt/pgsql

export PGDATA=/opt/pgsql/data

PATH=$PATH:$HOME/bin:$PGHOME/bin

export PATH
# User specific environment and startup programs
[postgres@localhost ~]$

初始化

su - postgres
/opt/pgsql/bin/initdb -D /opt/pgsql/data -W

-W, --pwprompt 在initdb的过程中为数据库超级用户设置一个密码。

--启动数据库

/opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l logfile start

su - postgres
 /opt/pgsql/bin/initdb -D /opt/pgsql/data -W

[root@localhost ~]# su - postgres
[postgres@localhost ~]$  /opt/pgsql/bin/initdb -D /opt/pgsql/data -W
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.UTF-8".
The default database encoding has accordingly been set to "UTF8".
initdb: could not find suitable text search configuration for locale "zh_CN.UTF-8"
The default text search configuration will be set to "simple".

Data page checksums are disabled.

Enter new superuser password: 
Enter it again: 

fixing permissions on existing directory /opt/pgsql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Asia/Shanghai
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: 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:

    /opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l logfile start

[postgres@localhost ~]$ ^C
-----启动数据库
[postgres@localhost ~]$ /opt/pgsql/bin/pg_ctl -D /opt/pgsql/data -l logfile start
waiting for server to start.... done
server started
[postgres@localhost ~]$ 

[postgres@localhost ~]$    /opt/pgsql/bin/pg_ctl -D /opt/pgsql/data  status
pg_ctl: server is running (PID: 59362)

---创建数据库

 /opt/pgsql/bin/createdb test
 /opt/pgsql/bin/psql test


[postgres@localhost ~]$   /opt/pgsql/bin/createdb test
[postgres@localhost ~]$  /opt/pgsql/bin/psql test
psql (14.2)
Type "help" for help.

test=# 


[postgres@localhost ~]$  /opt/pgsql/bin/psql
postgres=# \l
 postgres  | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
 template0 | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 test      | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |