Can't restore from a TimescaleDb backup because I need superuser access

Trying to restore from a backup ( https://docs.timescale.com/self-hosted/latest/backup-and-restore/pg-dump-and-restore/#restoring-an-entire-database-from-backup ) and I can't because

SELECT timescaledb_pre_restore();

SELECT timescaledb_pre_restore();

requires superuser access and I don't have permission:

postgres=> SELECT timescaledb_pre_restore();
ERROR:  permission denied to set parameter "timescaledb.restoring"
CONTEXT:  SQL statement "ALTER DATABASE postgres SET timescaledb.restoring ='on'"
PL/pgSQL function public.timescaledb_pre_restore() line 6 at EXECUTE

postgres=> SELECT timescaledb_pre_restore();
ERROR:  permission denied to set parameter "timescaledb.restoring"
CONTEXT:  SQL statement "ALTER DATABASE postgres SET timescaledb.restoring ='on'"
PL/pgSQL function public.timescaledb_pre_restore() line 6 at EXECUTE

What options do I have?

Timescale Documentation | Logical backups with pg_dump and pg_restore

Back up and restore a hypertable or entire database with native PostgreSQL commands

Supabase•3y ago•

2 replies

nckswt

Can't restore from a TimescaleDb backup because I need superuser access

Trying to restore from a backup ( https://docs.timescale.com/self-hosted/latest/backup-and-restore/pg-dump-and-restore/#restoring-an-entire-database-from-backup ) and I can't because

SELECT timescaledb_pre_restore();

SELECT timescaledb_pre_restore();

requires superuser access and I don't have permission:

postgres=> SELECT timescaledb_pre_restore();
ERROR:  permission denied to set parameter "timescaledb.restoring"
CONTEXT:  SQL statement "ALTER DATABASE postgres SET timescaledb.restoring ='on'"
PL/pgSQL function public.timescaledb_pre_restore() line 6 at EXECUTE

postgres=> SELECT timescaledb_pre_restore();
ERROR:  permission denied to set parameter "timescaledb.restoring"
CONTEXT:  SQL statement "ALTER DATABASE postgres SET timescaledb.restoring ='on'"
PL/pgSQL function public.timescaledb_pre_restore() line 6 at EXECUTE

What options do I have?

Timescale Documentation | Logical backups with pg_dump and pg_restore

Back up and restore a hypertable or entire database with native PostgreSQL commands

Can't restore from a TimescaleDb backup because I need superuser access

Similar Threads

Can't restore from a TimescaleDb backup because I need superuser access

Similar Threads

Similar Threads

Similar Threads