源码安装postgres sql服务

逃离我推掉我的手 2022-09-05 00:21 375阅读 0赞

官网  
[官网下载地址][Link 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70]  
拉到页面最后  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 1]  
选 source  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 2]  
选择自己需要的版本  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 3]  
我用的是12.3

然后等待下载　官网一般都很慢  
![在这里插入图片描述][d91ba5b7ea634df2841fea2792d9d606.png]  
1:上传到虚拟机  
![在这里插入图片描述][07e194fe6f034f63865a5171876477a5.png]

解压 : tarz -zxvf postgresql-12.3.tar.gz  
![在这里插入图片描述][922fa759b40f4617bc497e134304a867.png]

\#创建用户postgres  
useradd postgres  
\#安装依赖包  
yum install -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel openldap-devel python-devel gcc-c++ openssl-devel cmake gcc\* readline-devel  
mkdir /opt/postgres  
chown -R postgres:postgres /opt/postgres/

添加环境变量  
打开配置文件  
vi /etc/profile

移动到文件最后　添加下面配置  
\#export PATH=/data/deploy/postgres/bin:KaTeX parse error: Expected 'EOF', got '\#' at position 42: …eploy/postgres \#̲export PGDATA=/…LD\_LIBRARY\_PATH:PGHOME/lib/  
export PATH= P G H O M E / b i n : PGHOME/bin: PGHOME/bin:PATH  
![在这里插入图片描述][1a71f2e52f9942a2a359672b554499a9.png]  
重新加载配置文件  
source /etc/profile

检查环境 时间有点久  
./configure --prefix=/opt/postgres/ --with-python --with-libxml --with-libxslt

执行：  
Make

再执行 时间有点久  
make install  
![在这里插入图片描述][7050ba2fe701425c85f0e99548380624.png]  
初始化数据库  
切换用户  
su postgres

执行  
/opt/postgres/bin/initdb -D $PGDATA -E UTF8  
如果报错，修改 $PGDATA =>/opt/postgres/data  
/opt/postgres/bin/initdb -D /opt/postgres/data -E UTF8

修改配置　方便其他电脑连接  
![在这里插入图片描述][2b6d44024e26453b91a4b14720fee0d8.png]  
vi postgresql.conf  
\#找到listen\_addresses和port参数，修改如下，也可根据自己需求修改  
listen\_addresses = ‘\*’  
port = 5432

\#根据自己的网段设置下放行的ip规则  
vi pg\_hba.conf

IPv4 local connections:  
host all all 192.168.0.0/16 md5

host的配置参照  
!\[在这里插入图片描述\](https://img-blog.csdnimg.cn/93f1445ea9f54ad3891204204bc2b013.png  
启动：  
/opt/postgres/bin/pg\_ctl -l /opt/postgres/server.log start  
连接  
![在这里插入图片描述][4aec2f8cc1dd46179f25c771b281237d.png]  
备注：如果修改端口  
![在这里插入图片描述][d511323caa634b36bde2ceb163d5aa9d.png]  
创建账号  
CREATE USER test WITH PASSWORD ‘这里是密码，注意引号’;  
![在这里插入图片描述][30a5e992404c4f06b0d4a37384033137.png]  
Navcat 连接  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 4]  
最后做成系统服务

[root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# cd /data/soft/postgresql-13.4/contrib/start-scripts
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# chmod +x linux 
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# mv linux postgressql
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# vim postgressql 
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# ls /data/deploy/postgres/

编辑配置文件

vim postgressql

![在这里插入图片描述][bc19f030b3ce4954844756967232f16b.png]  
将启动文件拷贝到/etc/init.d下

[root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# mv postgressql /etc/init.d/
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# service postgressql status
    pg_ctl: server is running (PID: 16215)
    /data/deploy/postgres/bin/postgres "-D" "/data/deploy/postgres/data"

重启

[root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# service postgressql restart
    Restarting PostgreSQL: ok
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# ps -ef |grep postgressql
    root      7230  8605  0 10:02 pts/0    00:00:00 grep --color postgressql
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# ps -ef |grep postgres
    postgres  6953     1  0 10:02 ?        00:00:00 /data/deploy/postgres//bin/postmaster -D /data/deploy/postgres/data
    postgres  6955  6953  0 10:02 ?        00:00:00 postgres: checkpointer 
    postgres  6956  6953  0 10:02 ?        00:00:00 postgres: background writer 
    postgres  6957  6953  0 10:02 ?        00:00:00 postgres: walwriter 
    postgres  6958  6953  0 10:02 ?        00:00:00 postgres: autovacuum launcher 
    postgres  6959  6953  0 10:02 ?        00:00:00 postgres: stats collector 
    postgres  6960  6953  0 10:02 ?        00:00:00 postgres: logical replication launcher 
    root      7303  8605  0 10:02 pts/0    00:00:00 grep --color postgres
    postgres 22863 22806  3 09:50 ?        00:00:22 ipfs daemon --migrate=true
    [root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# service postgressql status
    pg_ctl: server is running (PID: 6953)
    /data/deploy/postgres/bin/postgres "-D" "/data/deploy/postgres/data"

设置开机自启

[root@otcdatabases-postgresql-test-192-168-1-48 start-scripts]# chkconfig postgressql on

postgres 创建 extension的时候报错，网上搜了好久终于找到了
    
    ```bash
    postgres=# create extension file_fdw;
    
    error:  could not open extension control file "/usr/local/pgsql/share/extension/file_fdw.control": no such file or directory

2.这个扩展默认没有按照，需要手动安装：

cd /usr/local/pgsql/contrib/file_fdw
     
    make
    make install

3.再次执行：`create extension file_fdw;`

[Link 1]: https://www.postgresql.org/download/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70]: /images/20220829/936a52f4ce6f4ac48e57d903397bea6f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 1]: /images/20220829/0628e99348d44145aadc5a510c07a94b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 2]: /images/20220829/5768151e370149368286476f3db69aea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 3]: /images/20220829/ac3f94eb453d447a942ad66cd764f43c.png
[d91ba5b7ea634df2841fea2792d9d606.png]: /images/20220829/7c9972547b0447d6b25d5251460ee4a3.png
[07e194fe6f034f63865a5171876477a5.png]: /images/20220829/71b61bdde78f4307a0b57daa4782d805.png
[922fa759b40f4617bc497e134304a867.png]: /images/20220829/f3a0b3921b2a44848e326fc421bf99a3.png
[1a71f2e52f9942a2a359672b554499a9.png]: /images/20220829/653b995b20c74aa9b67f60b512ecd44c.png
[7050ba2fe701425c85f0e99548380624.png]: /images/20220829/6b4541006b624360a4df5aa48da482eb.png
[2b6d44024e26453b91a4b14720fee0d8.png]: /images/20220829/2f9e59fab77143598f8d45578225c7c9.png
[4aec2f8cc1dd46179f25c771b281237d.png]: /images/20220829/b6712721198d40eea09852b946e9b0ff.png
[d511323caa634b36bde2ceb163d5aa9d.png]: /images/20220829/392e5bbb3ab6437faba22de21de6d221.png
[30a5e992404c4f06b0d4a37384033137.png]: /images/20220829/751468d95cd2497382eddddd7909422d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM4NDMyNzMy_size_16_color_FFFFFF_t_70 4]: /images/20220829/05618db685c94cb7a5c83bc5e1024861.png
[bc19f030b3ce4954844756967232f16b.png]: /images/20220829/503ecbe4f0524d5b901f6ae629f75de8.png