IvorySQL (Oracle)
使用瀚高开源的 IvorySQL 内核，基于 PostgreSQL 集群实现 Oracle 语法/PLSQL 兼容性。
Module:
IvorySQL 是一个开源的，旨在基于 PG 提供 “Oracle兼容性” 的 PostgreSQL 内核分支。
概览
IvorySQL 内核支持在 Pigsty 开源版本中提供，您的服务器需要互联网访问，直接从 IvorySQL 的官方仓库下载相关软件包。
请注意，直接将 IvorySQL 加入 Pigsty 默认软件仓库中会影响原生 PostgreSQL 内核的安装。Pigsty 专业版提供包括 IvorySQL 内核在内的离线安装解决方案。
当前 IvorySQL 的最新版本为 3.4，对应的 PostgreSQL 版本为 16.4。请注意，IvorySQL 当前仅在 EL8/EL9 上可用。
最后一个支持 EL7 的 IvorySQL 版本为 3.3，对应 PostgreSQL 16.3
安装
如果您的环境有互联网访问，您可以使用以下方式，直接将 IvorySQL 仓库加入到节点上，然后执行 PGSQL 剧本进行安装
./node.yml -t node_repo -e '{"node_repo_modules":"local,node,pgsql,ivory"}'
配置
以下参数需要针对 IvorySQL 数据库集群进行配置：
#----------------------------------#
# Ivory SQL Configuration
#----------------------------------#
node_repo_modules: local,node,pgsql,ivory # add ivorysql upstream repo
pg_mode: ivory # IvorySQL Oracle Compatible Mode
pg_packages: [ 'ivorysql patroni pgbouncer pgbackrest pg_exporter pgbadger vip-manager' ]
pg_libs: 'liboracle_parser, pg_stat_statements, auto_explain'
pg_extensions: [ ] # do not install any vanilla postgresql extensions
使用 Oracle 兼容性模式时，需要动态加载
liboracle_parser扩展插件。
客户端访问
IvorySQL 等效于 PostgreSQL 16，任何兼容 PostgreSQL 线缆协议的客户端工具都可以访问 IvorySQL 集群。
扩展列表
绝大多数 PGSQL 模块的 扩展插件 （非纯 SQL 类）都无法直接在 IvorySQL 内核上使用，如果需要使用，请针对新内核从源码重新编译安装。
目前 IvorySQL 内核自带了以下 101 个扩展插件。
| name | version | comment |
|---|---|---|
| hstore_plperl | 1.0 | transform between hstore and plperl |
| plisql | 1.0 | PL/iSQL procedural language |
| hstore_plperlu | 1.0 | transform between hstore and plperlu |
| adminpack | 2.1 | administrative functions for PostgreSQL |
| insert_username | 1.0 | functions for tracking who changed a table |
| dblink | 1.2 | connect to other PostgreSQL databases from within a database |
| dict_int | 1.0 | text search dictionary template for integers |
| amcheck | 1.3 | functions for verifying relation integrity |
| intagg | 1.1 | integer aggregator and enumerator (obsolete) |
| autoinc | 1.0 | functions for autoincrementing fields |
| bloom | 1.0 | bloom access method - signature file based index |
| dict_xsyn | 1.0 | text search dictionary template for extended synonym processing |
| btree_gin | 1.3 | support for indexing common datatypes in GIN |
| earthdistance | 1.1 | calculate great-circle distances on the surface of the Earth |
| file_fdw | 1.0 | foreign-data wrapper for flat file access |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings |
| btree_gist | 1.7 | support for indexing common datatypes in GiST |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers |
| citext | 1.6 | data type for case-insensitive character strings |
| isn | 1.2 | data types for international product numbering standards |
| ivorysql_ora | 1.0 | Oracle Compatible extenison on Postgres Database |
| jsonb_plperl | 1.0 | transform between jsonb and plperl |
| cube | 1.5 | data type for multidimensional cubes |
| dummy_index_am | 1.0 | dummy_index_am - index access method template |
| dummy_seclabel | 1.0 | Test code for SECURITY LABEL feature |
| hstore | 1.8 | data type for storing sets of (key, value) pairs |
| jsonb_plperlu | 1.0 | transform between jsonb and plperlu |
| lo | 1.1 | Large Object maintenance |
| ltree | 1.2 | data type for hierarchical tree-like structures |
| moddatetime | 1.0 | functions for tracking last modification time |
| old_snapshot | 1.0 | utilities in support of old_snapshot_threshold |
| ora_btree_gin | 1.0 | support for indexing oracle datatypes in GIN |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams |
| ora_btree_gist | 1.0 | support for oracle indexing common datatypes in GiST |
| pg_visibility | 1.2 | examine the visibility map (VM) and page-level visibility info |
| pg_walinspect | 1.1 | functions to inspect contents of PostgreSQL Write-Ahead Log |
| pgcrypto | 1.3 | cryptographic functions |
| pgstattuple | 1.5 | show tuple-level statistics |
| pageinspect | 1.12 | inspect the contents of database pages at a low level |
| pgrowlocks | 1.2 | show row-level locking information |
| pg_buffercache | 1.4 | examine the shared buffer cache |
| pg_stat_statements | 1.10 | track planning and execution statistics of all SQL statements executed |
| pg_freespacemap | 1.2 | examine the free space map (FSM) |
| plsample | 1.0 | PL/Sample |
| pg_prewarm | 1.2 | prewarm relation data |
| pg_surgery | 1.0 | extension to perform surgery on a damaged relation |
| seg | 1.4 | data type for representing line segments or floating-point intervals |
| postgres_fdw | 1.1 | foreign-data wrapper for remote PostgreSQL servers |
| refint | 1.0 | functions for implementing referential integrity (obsolete) |
| test_ext_req_schema1 | 1.0 | Required extension to be referenced |
| spgist_name_ops | 1.0 | Test opclass for SP-GiST |
| test_ext_req_schema2 | 1.0 | Test schema referencing of required extensions |
| test_shm_mq | 1.0 | Test code for shared memory message queues |
| sslinfo | 1.2 | information about SSL certificates |
| test_slru | 1.0 | Test code for SLRU |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab |
| bool_plperl | 1.0 | transform between bool and plperl |
| tcn | 1.0 | Triggered change notifications |
| test_ext_req_schema3 | 1.0 | Test schema referencing of 2 required extensions |
| test_bloomfilter | 1.0 | Test code for Bloom filter library |
| test_copy_callbacks | 1.0 | Test code for COPY callbacks |
| test_ginpostinglist | 1.0 | Test code for ginpostinglist.c |
| test_custom_rmgrs | 1.0 | Test code for custom WAL resource managers |
| test_integerset | 1.0 | Test code for integerset |
| test_ddl_deparse | 1.0 | Test code for DDL deparse feature |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit |
| test_ext1 | 1.0 | Test extension 1 |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit |
| test_ext2 | 1.0 | Test extension 2 |
| unaccent | 1.1 | text search dictionary that removes accents |
| test_ext3 | 1.0 | Test extension 3 |
| test_ext4 | 1.0 | Test extension 4 |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) |
| test_ext5 | 1.0 | Test extension 5 |
| worker_spi | 1.0 | Sample background worker |
| test_ext6 | 1.0 | test_ext6 |
| test_lfind | 1.0 | Test code for optimized linear search functions |
| xml2 | 1.1 | XPath querying and XSLT |
| test_ext7 | 1.0 | Test extension 7 |
| plpgsql | 1.0 | PL/pgSQL procedural language |
| test_ext8 | 1.0 | Test extension 8 |
| test_parser | 1.0 | example of a custom parser for full-text search |
| test_pg_dump | 1.0 | Test pg_dump with an extension |
| test_ext_cine | 1.0 | Test extension using CREATE IF NOT EXISTS |
| test_predtest | 1.0 | Test code for optimizer/util/predtest.c |
| test_ext_cor | 1.0 | Test extension using CREATE OR REPLACE |
| test_rbtree | 1.0 | Test code for red-black tree library |
| test_ext_cyclic1 | 1.0 | Test extension cyclic 1 |
| test_ext_cyclic2 | 1.0 | Test extension cyclic 2 |
| test_ext_extschema | 1.0 | test @extschema@ |
| test_regex | 1.0 | Test code for backend/regex/ |
| test_ext_evttrig | 1.0 | Test extension - event trigger |
| bool_plperlu | 1.0 | transform between bool and plperlu |
| plperl | 1.0 | PL/Perl procedural language |
| plperlu | 1.0 | PL/PerlU untrusted procedural language |
| hstore_plpython3u | 1.0 | transform between hstore and plpython3u |
| jsonb_plpython3u | 1.0 | transform between jsonb and plpython3u |
| ltree_plpython3u | 1.0 | transform between ltree and plpython3u |
| plpython3u | 1.0 | PL/Python3U untrusted procedural language |
| pltcl | 1.0 | PL/Tcl procedural language |
| pltclu | 1.0 | PL/TclU untrusted procedural language |
请注意，Pigsty 不对使用 IvorySQL 内核承担任何质保责任，使用此内核遇到的任何问题与需求请联系原厂解决。
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.