https://prefect.io logo
#prefect-community
Title
# prefect-community
a

Amol Shirke

08/30/2022, 7:01 PM
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

Ryan Peden

08/30/2022, 7:23 PM
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

Amol Shirke

08/30/2022, 7:24 PM
Is it the only extension required?
r

Ryan Peden

08/30/2022, 7:26 PM
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

Amol Shirke

08/30/2022, 7:27 PM
Great thx
3 Views