Fixing Integrity check errors - Mailing list pgsql-novice

From flik
Subject Fixing Integrity check errors
Date
Msg-id 9bde7204-1b4c-8702-4593-5afd0607c5d2@gmail.com
Whole thread Raw
Responses Re: Fixing Integrity check errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice

Hi!

What would be the best way to solve integrity errors (unique constraints) caused by a badly done dump/restore? My best guess as ignorant ass, it's simply to dump the current data (only), start a new project, apply the migrations and loading back data.
Given that the schema is exactly the same, would this work? If so, how can I do it with postgres?
I already tried to pg_dump --data-only but I keep getting weird errors.

Sorry if my message is confusing-confused, I'm quite new with databases!

pgsql-novice by date:

Previous
From: Bill Ross
Date:
Subject: postgres on pinephone pro (linux phone)?
Next
From: Tom Lane
Date:
Subject: Re: Fixing Integrity check errors