Error while PROCESSING TOC. when trying to restore dbbackup file

[babaee74]

Bug Report

dbbackup.db.exceptions.CommandConnectorError: Error running: pg_restore --dbname=postgresql://adminnn:[email protected]:5432/apiusersdb --single-transaction --clean
pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1; 3079 13039 EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql
Command was: DROP EXTENSION plpgsql;

Describe the bug

I did backup using this command:
python3 manage.py dbbackup --compress
and i got this file:
default-robo-server-2023-11-09-202002.psql.bin.gz

then i tried to restore it using the command below:
python3 manage.py dbrestore --uncompress -I /home/esi/dbbackup/default-robo-server-2023-11-09-202002.psql.bin.gz --traceback
and i got the error below:
dbbackup.db.exceptions.CommandConnectorError: Error running: pg_restore --dbname=postgresql://adminnn:[email protected]:5432/apiusersdb --single-transaction --clean pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1; 3079 13039 EXTENSION plpgsql pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql Command was: DROP EXTENSION plpgsql;

I also did use -c to decrypt despite not using it when I was doing backup and it did not work

To Reproduce

Steps to reproduce the behavior

Expected behavior

the dtaabase has been restored

Versions

Django-dbbackup

django 3.2.4
django-dbbackup==4.0.2

External tools

• Python 3.9.10
• ubuntu 20.04