postgres插件安装.txt - 墨天轮文档

postgres插件安装.txt

chkl

2页

0次

2023-12-04

免费下载

postgres=# CREATE EXTENSION dblink;

ERROR: could not open extension control file "/usr/local/pgsql/postgresql-14.4/

share/extension/dblink.control": No such file or directory

## 安装 dblink

[root@cwaiserver postgresql-14.4]# ls contrib/file_fdw/

data/ file_fdw.c input/ sql/

expected/ file_fdw.control Makefile

file_fdw--1.0.sql .gitignore output/

[root@cwaiserver postgresql-14.4]# ls contrib/db*

dblink--1.0--1.1.sql dblink.c input pg_service.conf

dblink--1.1--1.2.sql dblink.control Makefile sql

dblink--1.2.sql expected output

[root@cwaiserver postgresql-14.4]# ls -lh /usr/local/pgsql/postgresql-14.4/shar

ls: cannot access /usr/local/pgsql/postgresql-14.4/share/extension/file_fdw*: No

[root@cwaiserver postgresql-14.4]# pwd

/usr/local/pgsql/postgresql-14.4

[root@cwaiserver contrib]# cd dblink/

[root@cwaiserver dblink]# ls

dblink--1.0--1.1.sql dblink.c input pg_service.conf

dblink--1.1--1.2.sql dblink.control Makefile sql

dblink--1.2.sql expected output

[root@cwaiserver dblink]# make

[root@cwaiserver dblink]# make install

[postgres@cwaiserver ~]$ psql

psql (14.4)

Type "help" for help.

postgres=# CREATE EXTENSION dblink;

CREATE EXTENSION

postgres=# select * from pg_extension;

nfig | extcondition

-------+---------+----------+--------------+----------------+------------+------

-----+--------------

13878 | plpgsql | 10 | 11 | f | 1.0 |

16828 | dblink | 10 | 2200 | t | 1.2 |

(2 rows)

postgres=#

## 安装 cront 定时器和分区管理 pg_partman

1. 创建目录存放 pg_cron 扩展所需插件:

mkdir crondata

chown -R postgres:postgres /pgsoft/crondata/

2. 解压文件：

tar -xvf pg_cron-1.2.0.tar.gz

3. 进入加压后的目录进行编译和安装：

make PG_CONFIG=/pgsoft/pgsql/bin/pg_config

make install PG_CONFIG=/pgsoft/pgsql/bin/pg_config

4.编辑 postgresql.conf

vi /pgsoft/pgsql/data/postgresql.conf

添加：

shared_preload_libraries = 'pg_cron'

cron.database_name='postgres' #pg_cron 元数据存放的数据库

of 2

免费下载

相关文档

评论