Hello, I am setting PG db for orion. I don't have ...
# ask-community
a
Hello, I am setting PG db for orion. I don't have super user rights on db. I am able to create tables but creating extensions is problem. How can I know what extensions orion will require and is there anything else while setup which require SU right and outside of normal schema objects? Thanks
1
r
You will need the
pg_trgm
extension added to a schema that is in your user's
search_path
This doesn't show up in the docs yet, but will be there in the next day or two 🙂
👍 1
a
Is it the only extension required?
r
I believe so; last week, I ran Orion on a fresh install of Postgres as a non-superuser, and
pg_trgm
was the only extension I had to enable.
a
Great thx