search

Vonng / pigsty

Battery-Included PostgreSQL Distro as a Free RDS Alternative
https://pigsty.io
GNU Affero General Public License v3.0
3.01k stars 242 forks source link

CentOS 7.9 x86_64 failed due to postgis34 extension not exists #375

Closed NJCHello closed 4 months ago

NJCHello commented 4 months ago

TASK [pgsql : install postgres extensions] **** failed: [172.28.172.197] (item=postgis34_${pg_version} timescaledb-2-postgresql-${pg_version} pgvector_${pgversion}* hydra${pg_version}) => {"ansible_loopvar": "item", "changed": false, "item": "postgis34${pg_version} timescaledb-2-postgresql-${pgversion}* pgvector${pgversion}* hydra${pg_version}", "msg": "No package matching 'postgis34_15' found available, installed or updated", "rc": 126, "results": ["No package matching 'postgis34_15*' found available, installed or updated"]}

PLAY RECAP **** 172.28.172.197 : ok=215 changed=163 unreachable=0 failed=1 skipped=40 rescued=0 ignored=0
localhost : ok=6 changed=3 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0

Vonng commented 4 months ago

el7 does not have postgis34 ， use postgis33 instead

NJCHello commented 4 months ago

那自动生成的pigsty.yml文件这里要修改一下 image 另外还有两个问题哈 1、如果我想安装pg-12版本，是不是在执行了cd ~/pigsty; ./bootstrap; ./configure;这三步之后修改pigsty.yml文件，在pigsty.yml的repo_upstream:和repo_packages中加12的信息，然后修改pg_version:12；然后执行./install.yml;就可以了？（有没有现成的针对pg-12的pigsty.yml脚本） 2、如果执行./install.yml时失败了，有一键卸载的脚本吗，还是直接删除pigsty文件夹就行，还是要一点点卸载？

Vonng commented 4 months ago

  1. fixed in https://github.com/Vonng/pigsty/commit/372513e1105d616b00aaedff691b987c9705d21e

  2. example build config for pg 12 : https://github.com/Vonng/pigsty/blob/v2.5.1/files/pigsty/build.yml

  3. ./infra-rm.yml , ./pgsql-rm.yml As for other module, we don't offer uninstall script, but there are unsintall task in the playbooks, check the module docs for detail