# polar > PolarDB for PostgreSQL 内核，提供 Aurora 风格的存算分离能力 --- LLMS 索引： [llms.txt](/zh/llms.txt) --- `polar` 配置模板使用阿里云 PolarDB for PostgreSQL 数据库内核替代原生 PostgreSQL，提供"云原生" Aurora 风格的存算分离能力。 完整教程请参考：**[PolarDB for PostgreSQL (POLAR) 内核使用说明](/docs/pgsql/kernel/polardb/)**；所有内核分支的差异与版本口径见 [PGSQL 内核总览](/docs/pgsql/kernel/)。 -------- ## 配置概览 - 配置名称： `polar` - 节点数量： 单节点 - 配置说明：使用 PolarDB for PostgreSQL 内核 - 适用系统：`el8`, `el9`, `el10`, `d12`, `d13`, `u22`, `u24`, `u26` - 适用架构：`x86_64`, `aarch64` - 相关配置：[`meta`](/docs/conf/meta/) 启用方式： ```bash ./configure -c polar [-i ] ``` -------- ## 配置内容 源文件地址：[`pigsty/conf/polar.yml`](https://github.com/pgsty/pigsty/blob/main/conf/polar.yml) ```yaml --- #==============================================================# # File : polar.yml # Desc : Pigsty 1-node PolarDB Kernel Config Template # Ctime : 2020-08-05 # Mtime : 2026-07-08 # Docs : https://pigsty.io/docs/conf/polar # License : Apache-2.0 @ https://pigsty.io/docs/about/license/ # Copyright : 2018-2026 Ruohang Feng / Vonng (rh@vonng.com) #==============================================================# # This is the config template for PolarDB PG Kernel, # Which is a PostgreSQL 17 fork with RAC flavor features # tutorial: https://pigsty.io/docs/pgsql/kernel/polardb # # Usage: # curl https://repo.pigsty.io/get | bash # ./configure -c polar # ./deploy.yml all: children: infra: { hosts: { 10.10.10.10: { infra_seq: 1 }} ,vars: { repo_enabled: false }} etcd: { hosts: { 10.10.10.10: { etcd_seq: 1 }} ,vars: { etcd_cluster: etcd }} #minio: { hosts: { 10.10.10.10: { minio_seq: 1 }} ,vars: { minio_cluster: minio }} #----------------------------------------------# # PolarDB Database Cluster #----------------------------------------------# pg-meta: hosts: 10.10.10.10: { pg_seq: 1, pg_role: primary } vars: pg_cluster: pg-meta pg_users: - {name: dbuser_meta ,password: DBUser.Meta ,pgbouncer: true ,roles: [dbrole_admin] ,comment: pigsty admin user } - {name: dbuser_view ,password: DBUser.Viewer ,pgbouncer: true ,roles: [dbrole_readonly] ,comment: read-only viewer for meta database } pg_databases: - {name: meta ,baseline: cmdb.sql ,comment: pigsty meta database ,schemas: [pigsty]} pg_hba_rules: # https://pigsty.io/docs/pgsql/config/hba - { user: all ,db: all ,addr: intra ,auth: pwd ,title: 'everyone intranet access with password' ,order: 800 } pg_crontab: # https://pigsty.io/docs/pgsql/admin/crontab - '00 01 * * * /pg/bin/pg-backup full' # PolarDB Ad Hoc Settings pg_version: 17 # PolarDB PG is based on PG 17 pg_mode: polar # PolarDB PG Compatible mode pg_packages: [ polardb, pgsql-common ] # Replace PG kernel with PolarDB kernel pg_exporter_exclude_database: 'template0,template1,postgres,polardb_admin' pg_default_roles: # PolarDB require replicator as superuser - { name: dbrole_readonly ,login: false ,comment: role for global read-only access } - { name: dbrole_offline ,login: false ,comment: role for restricted read-only access } - { name: dbrole_readwrite ,login: false ,roles: [dbrole_readonly] ,comment: role for global read-write access } - { name: dbrole_admin ,login: false ,roles: [pg_monitor, dbrole_readwrite] ,comment: role for object creation } - { name: postgres ,superuser: true ,comment: system superuser } - { name: replicator ,superuser: true ,replication: true ,roles: [pg_monitor, dbrole_readonly] ,comment: system replicator } # <- superuser is required for replication - { name: dbuser_dba ,superuser: true ,roles: [dbrole_admin] ,pgbouncer: true ,pool_mode: session, pool_connlimit: 16 ,comment: pgsql admin user } - { name: dbuser_monitor ,roles: [pg_monitor] ,pgbouncer: true ,parameters: {log_min_duration_statement: 1000 } ,pool_mode: session ,pool_connlimit: 8 ,comment: pgsql monitor user } vars: # global variables #----------------------------------------------# # INFRA : https://pigsty.io/docs/infra/param #----------------------------------------------# version: v4.5.0 # pigsty version string admin_ip: 10.10.10.10 # admin node ip address region: default # upstream mirror region: default,china,europe infra_portal: # infra services exposed via portal home : { domain: i.pigsty } # default domain name #----------------------------------------------# # NODE : https://pigsty.io/docs/node/param #----------------------------------------------# nodename_overwrite: false # do not overwrite node hostname on single node mode node_repo_modules: node,infra,pgsql # add these repos directly to the singleton node node_tune: oltp # node tuning specs: oltp,olap,tiny,crit #----------------------------------------------# # PGSQL : https://pigsty.io/docs/pgsql/param #----------------------------------------------# pg_version: 17 # PolarDB is compatible with PG 17 pg_conf: oltp.yml # pgsql tuning specs: {oltp,olap,tiny,crit}.yml #----------------------------------------------# # PASSWORD : https://pigsty.io/docs/setup/security/ #----------------------------------------------# grafana_admin_password: pigsty grafana_view_password: DBUser.Viewer pg_admin_password: DBUser.DBA pg_monitor_password: DBUser.Monitor pg_replication_password: DBUser.Replicator patroni_password: Patroni.API haproxy_admin_password: pigsty minio_secret_key: S3User.MinIO etcd_root_password: Etcd.Root ... ``` -------- ## 配置解读 `polar` 模板使用阿里云开源的 PolarDB for PostgreSQL 内核，提供云原生数据库能力。 **关键特性**： - 存算分离架构，计算节点和存储节点可独立扩展 - 支持一写多读，读副本秒级扩展 - 兼容 PostgreSQL 生态，保持 SQL 兼容性 - 支持共享存储场景，适合云环境部署 - 默认 PolarDB 内核路径为 `/usr/polar-17` - 可用扩展以 PolarDB 17 内核为准，常用扩展可参考 [`pgaudit`](https://pigsty.cc/ext/e/pgaudit/)、[`pg_partman`](https://pigsty.cc/ext/e/pg_partman/)、[`pg_profile`](https://pigsty.cc/ext/e/pg_profile/)、[`pg_repack`](https://pigsty.cc/ext/e/pg_repack/)、[`pg_stat_kcache`](https://pigsty.cc/ext/e/pg_stat_kcache/)、[`pg_cron`](https://pigsty.cc/ext/e/pg_cron/)、[`pg_hint_plan`](https://pigsty.cc/ext/e/pg_hint_plan/) **适用场景**： - 需要存算分离架构的云原生场景 - 读多写少的业务负载 - 需要快速扩展读副本的场景 - 评估 PolarDB 特性的测试环境 **注意事项**： - PolarDB 当前基于 PostgreSQL 17 - 复制用户需要超级用户权限（与原生 PostgreSQL 不同） - 部分 PostgreSQL 扩展可能存在兼容性问题 - 当前模板已提供 `x86_64` 与 `aarch64` 软件包支持