Need superuser privileges to use pg_dump and pg_restore in https://portal.managed.timescale.com service

Aiven Community
1

Hi!

I am a Managed Timescale customer (Managed Service for TimescaleDB) and I have an issue with user privileges.

I am not able to create a role with superuser privileges and I do not have the credentials for the 2 existing superuser roles (postgres and _aiven).

Superuser privileges are necessary to use properly pg_dump and pg_restore as indicated in Timescale documentation:

This is needed, for example, to dump a database from the Cloud to my local Linux instance for development purposes.

By following the instructions above without accessing with superuser privileges, I am able to dump and restore the hypertables but something weird happens with the continuous aggregates.

The materialized hypertables are listed as hypertables (SELECT * FROM timescaledb_information.hypertables) rather than as materialization hypertables (SELECT * FROM timescaledb_information.continuous_aggregates);

Also, when trying to access the content of the materialized views, an error is shown: invalid materialized hypertable ID.

Any hint how I could solve this issue?

Thanks,

Bernardo

2

Hey there, Bernardo! Looks like you got an answer over here so closing this one out as a duplicate. :slight_smile: