Hello
My customer is using postgres user to manage standard data and also timescaledb data. They want to access all data with user that has limited permissions other than postgres user. How can I change timescaledb related schema’s owner safely
Best regards
Hello, and welcome to the forum!
Am I correct in saying you want to store the timescaledb data the public schema? This is already possible for hypertables (you can create them in any schema you want) and chunks (Timescale creates several dedicated schemas for internal data).
If you are instead wanting to move all Timescale objects (functions etc…) out of the public schema, then this can be done at extenstion creation time with CREATE EXTENSION timescaledb WITH SCHEMA myschema
-James
Thanks, I will try and share update about status