I took a backup from a wazo20.15 VM, with pg-backup.
I dropped db asterisk
Then I did a restore (pg-restore) from that dumpfile on the same wazo20.15 VM.
During restore I get the following error:
root@newwazo:/var/tmp/pg-backup# sudo -u postgres pg_restore -C -d postgres asterisk-*.dump
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4860; 2606 17061 CONSTRAINT auth_acl_template auth_acl_template_template asterisk
pg_restore: [archiver (db)] could not execute query: ERROR: could not create unique index “auth_acl_template_template”
DETAIL: Key (template)=(confd.users.read) is duplicated.
Command was: ALTER TABLE ONLY public.auth_acl_template
ADD CONSTRAINT auth_acl_template_template UNIQUE (template);
WARNING: errors ignored on restore: 1
I do not have the impression that is is a severe error, but has someone an idea?