记一次 Centos7 PostgreSql 数据库安装扩展

r囧r小猫 2023-07-18 14:03 23阅读 0赞

一、数据库搭建

1、yum 指定目录安装

[https://blog.csdn.net/llwy1428/article/details/105143053][https_blog.csdn.net_llwy1428_article_details_105143053]

2、yum 直接安装

[https://blog.csdn.net/llwy1428/article/details/102486414][https_blog.csdn.net_llwy1428_article_details_102486414]

3、编译安装

[https://blog.csdn.net/llwy1428/article/details/95444151][https_blog.csdn.net_llwy1428_article_details_95444151]

4、PostgreSql 基本操作

[https://blog.csdn.net/llwy1428/article/details/102598732][https_blog.csdn.net_llwy1428_article_details_102598732]

二、扩展安装

1、下载 epel-7.repo

[root@pgadmin ~]# cd /etc/yum.repos.d/
    [root@pgadmin yum.repos.d]# wget https://mirrors.aliyun.com/repo/epel-7.repo

2、安装工具

[root@localhost ~]# yum install pgagent_11 postgis25_11 -y

3、查看当前服务器可用的 Extension 扩展列表

# 切换用户
    [root@localhost ~]# su - postgres
    Last login: Mon Mar 16 21:15:46 CST 2020 on pts/3
    # 进入 postgresql 命令行
    [postgres@localhost ~]$ psql
    psql (11.5)
    Type "help" for help.
    
    postgres=# select name from pg_available_extensions;
                 name             
    ------------------------------
     insert_username
     dict_int
     adminpack
     amcheck
     intagg
     autoinc
     intarray
     bloom
     file_fdw
     dblink
     btree_gin
     fuzzystrmatch
     seg
     btree_gist
     jsonb_plperl
     hstore
     citext
     isn
     jsonb_plperlu
     cube
     hstore_plperl
     dict_xsyn
     hstore_plperlu
     earthdistance
     lo
     ltree
     pg_trgm
     tcn
     moddatetime
     pageinspect
     pg_visibility
     pgstattuple
     postgres_fdw
     pg_buffercache
     xml2
     pg_freespacemap
     refint
     sslinfo
     tablefunc
     pg_prewarm
     pgcrypto
     pg_stat_statements
     pgrowlocks
     timetravel
     tsm_system_rows
     address_standardizer
     tsm_system_time
     unaccent
     address_standardizer_data_us
     uuid-ossp
     postgis
     postgis_sfcgal
     postgis_tiger_geocoder
     postgis_topology
     plpgsql
    (55 rows)

4、查看当前数据库列表

5、在默认数据库中安装 pgagent 扩展

postgres=# create extension pgagent;
    CREATE EXTENSION

安装扩展成功

服务启动、关闭、设置开机启动

服务启动
    [root@localhost ~]# systemctl start pgagent_11
    服务停止
    [root@localhost ~]# systemctl stop pgagent_11
    服务当前状态查看
    [root@localhost ~]# systemctl status pgagent_11
    服务开机启动
    [root@localhost ~]# systemctl enable pgagent_11
    禁止服务开机启动
    [root@localhost ~]# systemctl disable pgagent_11

6、在指定数据库中 安装扩展

（1）创建测试数据库，并查看列表

（2）切换数据库

postgres=# \c pgtest
    You are now connected to database "pgtest" as user "postgres".
    pgtest=#

（3）安装扩展  postgis

pgtest=# create extension "uuid-ossp";
    CREATE EXTENSION

（4）安装扩展  uuid-ossp

pgtest=# create extension postgis;
    CREATE EXTENSION

（5）安装扩展  ltree

pgtest=# create extension "ltree";
    CREATE EXTENSION

（6）安装扩展  timetravel

pgtest=# create extension "timetravel";
    CREATE EXTENSION

其他扩展：略。

（7）查看当前已安装的扩展

（8）删除Extension扩展，查看结果

至此，Centos7  PostgreSql  数据库安装插件基本操作完毕！

希望能够对您有所帮助！

[https_blog.csdn.net_llwy1428_article_details_105143053]: https://blog.csdn.net/llwy1428/article/details/105143053
[https_blog.csdn.net_llwy1428_article_details_102486414]: https://blog.csdn.net/llwy1428/article/details/102486414
[https_blog.csdn.net_llwy1428_article_details_95444151]: https://blog.csdn.net/llwy1428/article/details/95444151
[https_blog.csdn.net_llwy1428_article_details_102598732]: https://blog.csdn.net/llwy1428/article/details/102598732