Content-Type: multipart/alternative;
 boundary="------------Sc0S0KqfpneeslMjeqzSkJ4H"
Message-ID: <9bde7204-1b4c-8702-4593-5afd0607c5d2@gmail.com>
Date: Mon, 14 Mar 2022 21:14:55 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.6.2
To: pgsql-novice@lists.postgresql.org
Content-Language: en-US
From: flik <flikreview@gmail.com>
Subject: Fixing Integrity check errors
Archived-At: 
 <https://www.postgresql.org/message-id/9bde7204-1b4c-8702-4593-5afd0607c5d2%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Sc0S0KqfpneeslMjeqzSkJ4H
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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!

--------------Sc0S0KqfpneeslMjeqzSkJ4H
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p class="_1qeIAgB0cPwnLhDF9XSiJM" style="margin: 0px; padding: 0px
      0px 0.25em; border: 0px; font-style: normal;
      font-variant-ligatures: normal; font-variant-caps: normal;
      font-variant-numeric: inherit; font-variant-east-asian: inherit;
      font-weight: 400; font-stretch: inherit; font-size: 14px;
      line-height: inherit; font-family: &quot;Noto Sans&quot;, Arial,
      sans-serif; vertical-align: baseline; color: rgb(26, 26, 27);
      letter-spacing: normal; orphans: 2; text-align: start;
      text-indent: 0px; text-transform: none; white-space: normal;
      widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
      background-color: rgb(255, 255, 255); text-decoration-thickness:
      initial; text-decoration-style: initial; text-decoration-color:
      initial;">Hi!</p>
    <p class="_1qeIAgB0cPwnLhDF9XSiJM" style="margin: 0px; padding:
      0.8em 0px 0.25em; border: 0px; font-style: normal;
      font-variant-ligatures: normal; font-variant-caps: normal;
      font-variant-numeric: inherit; font-variant-east-asian: inherit;
      font-weight: 400; font-stretch: inherit; font-size: 14px;
      line-height: inherit; font-family: &quot;Noto Sans&quot;, Arial,
      sans-serif; vertical-align: baseline; color: rgb(26, 26, 27);
      letter-spacing: normal; orphans: 2; text-align: start;
      text-indent: 0px; text-transform: none; white-space: normal;
      widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
      background-color: rgb(255, 255, 255); text-decoration-thickness:
      initial; text-decoration-style: initial; text-decoration-color:
      initial;">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.<br>
      Given that the schema is exactly the same, would this work? If so,
      how can I do it with postgres?<br>
      I already tried to pg_dump --data-only but I keep getting weird
      errors.</p>
    <p class="_1qeIAgB0cPwnLhDF9XSiJM" style="margin: 0px; padding:
      0.8em 0px 0px; border: 0px; font-style: normal;
      font-variant-ligatures: normal; font-variant-caps: normal;
      font-variant-numeric: inherit; font-variant-east-asian: inherit;
      font-weight: 400; font-stretch: inherit; font-size: 14px;
      line-height: inherit; font-family: &quot;Noto Sans&quot;, Arial,
      sans-serif; vertical-align: baseline; color: rgb(26, 26, 27);
      letter-spacing: normal; orphans: 2; text-align: start;
      text-indent: 0px; text-transform: none; white-space: normal;
      widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
      background-color: rgb(255, 255, 255); text-decoration-thickness:
      initial; text-decoration-style: initial; text-decoration-color:
      initial;">Sorry if my message is confusing-confused, I'm quite new
      with databases!</p>
  </body>
</html>

--------------Sc0S0KqfpneeslMjeqzSkJ4H--