| From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
|---|---|
| To: | andreas(at)a-kretschmer(dot)de |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pg_restore fails due to foreign key violation |
| Date: | 2018-12-10 13:56:03 |
| Message-ID: | CABeG9Lt3yJGX=2cFGgKThxtj+KwU4BLy9e70FoPhcp6Nzmrumw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
El lun., 10 dic. 2018 a las 7:21, Andreas Kretschmer (<
andreas(at)a-kretschmer(dot)de>) escribió:
>
> Am 10.12.18 um 11:15 schrieb Olga Vingurt:
> > After playing with the dump and importing schema first and data next
> > without the triggers we indeed see that data is missing in the table
> > i.e. dump is not consistent.
> > We don't stop the application which uses database during the dump but
> > according to the documentation the dump still should be consistent.
>
>
> please check if the data are consistent on the source database system.
>
I would start by running amcheck to see if there is index corruption
somewhere, as that can lead to data corruption (in particular if the
corrupted index is a unique or primary key index)
Regards,
--
Martín Marqués
It’s not that I have something to hide,
it’s that I have nothing I want you to see
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-12-10 14:35:43 | Re: Tables(s) that feed pg_controldata |
| Previous Message | Laurenz Albe | 2018-12-10 11:31:37 | Re: Temp tables |