I don't have personal experience with this, but I thought it was fairly common to DEFER constraint checking until after a restore completed, for exactly this reason. - John Burger MITRE
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных