PostgreSQL
The vanilla PostgreSQL kernel with 420+ extensions
PostgreSQL is the most advanced & popular open source database in the world.
Pigsty supports PostgreSQL 13 ~ 17, and provides 420+ extensions alone with it.
Get Started
install Pigsty’s with the pgsql config template.
./configure -c pgsql # use percona postgres kernel
./install.yml # setup everything with pigstyMost of the config template is use the PostgreSQL kernel by default, such as:
meta: DEFAULT, postgres with core extensions (vector, postgis, timescale)rich: postgres with all extensions installedslim: postgres only without monitor infrafull: the 4-node sandbox for HA demonstrationpgsql: the minimal postgres kernel config example
Configure
Nothing special needs to be tuned for vanilla PostgreSQL kernel:
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 }
pg_databases:
- { name: meta, baseline: cmdb.sql ,comment: pigsty meta database ,schemas: [pigsty] ,extensions: [ vector ]}
pg_hba_rules:
- { user: dbuser_view , db: all ,addr: infra ,auth: pwd ,title: 'allow grafana dashboard access cmdb from infra nodes' }
node_crontab: [ '00 01 * * * postgres /pg/bin/pg-backup full' ] # make a full backup every 1am
pg_packages: [ pgsql-main, pgsql-common ] # pg kernel and common utils
#pg_extensions: [pg17-time ,pg17-gis ,pg17-rag ,pg17-fts ,pg17-feat ,pg17-lang ,pg17-type ,pg17-util ,pg17-func ,pg17-admin ,pg17-stat ,pg17-sec ,pg17-fdw ,pg17-sim ,pg17-etl ,pg17-olap]To use a different PostgreSQL major version, you can configure with -v parameter:
./configure -c pgsql -v 17 # use postgresql 17
./configure -c pgsql -v 16 # use postgresql 16
./configure -c pgsql -v 15 # use postgresql 15
./configure -c pgsql -v 14 # use postgresql 14
./configure -c pgsql -v 13 # use postgresql 13If PostgreSQL cluster is already installed, you'll need to uninstall it before installing the new version
./pgsql-rm.yml # -l pg-meta