postgres-operator icon indicating copy to clipboard operation
postgres-operator copied to clipboard

Install ltree extension in postgres

Open ravirajshankarl opened this issue 3 years ago • 0 comments

Hi Colleagues,

I have tried to install ltree extention following link, after deploy still installed_version value is empty. Please guide me on how to install

select * from pg_available_extensions where name='ltree'; name | default_version | installed_version | comment -------+-----------------+-------------------+------------------------------------------------- ltree | 1.2 | | data type for hierarchical tree-like structures

I have added my configuration settings as below

users: {}

databases:
  aorsdb: aorsdbuser

preparedDatabases:
  aorsdb:
    extensions:
      ltree: "public"

ravirajshankarl avatar Jul 13 '22 13:07 ravirajshankarl