Benji with PostgreSQL - reached maximum value of sequence

[bbs2web]

Can't delete old backups at the moment due to PostgreSQL yielding an error that 'deleted_blocks_id_seq' is at the maximum value of sequence.

I found a page on the net which gives various ways to work around it, would it be save to unset a maximum, or any recommendations on how we should proceed?

Error in Benji:
ERROR: DataError: (psycopg2.errors.SequenceGeneratorLimitExceeded) nextval: reached maximum value of sequence "deleted_blocks_id_seq" (2147483647)

Page on the internet:
https://database.guide/6-ways-to-fix-nextval-reached-maximum-value-of-sequence-in-postgresql/

[wech71]

Same here. Fortunately the deleted_blocks table was empty, so I could reset the deleted_blocks_id_seq to 0.

Probably the id column and sequence should be changed to a bigint (64 bit value) and the sequence limit removed.