postgres-operator
postgres-operator copied to clipboard
Install ltree extension in postgres
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"