Being new to Postgres/Timescale I used the super user for too long and am migrating to a less privileged user. I can change the owner of the tables I’ve written successfully, but when I try to change the owner on a chunk table like
ALTER TABLE _timescaledb_internal._hyper_1841_1687_chunk OWNER TO <notsuperuser>;
I get the following error.
[Code: 0, SQL State: 0A000] ERROR: operation not supported on chunk tables
Does it matter the chunks are owned by a different user than the tables I’ve written?
Tables written by the previous user will likely not be modified (never say never, but unlikely), and any future tables will be created and written to by the correct user. Do I care that the table owners between the chunk tables and the postgres tables written previously have different users?