Re: error in vacuum
| От | Dave Peticolas |
|---|---|
| Тема | Re: error in vacuum |
| Дата | |
| Msg-id | CAPRbp047pUGj6GJLuBsJzc_YMGmSisYWmon_H_d+CE+O6XFkYQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: error in vacuum (Dave Peticolas <dave@krondo.com>) |
| Ответы |
Re: error in vacuum
|
| Список | pgsql-general |
On Sat, Sep 1, 2018 at 5:28 PM Dave Peticolas <dave@krondo.com> wrote:
On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:On 09/01/2018 04:47 PM, Dave Peticolas wrote:
> I'm seeing this error on a table repeatedly:
>
> found update xid 3433096759 <tel:%28343%29%20309-6759> from before
> relfrozenxid 3498422955
Where is this, your primary or the instance you are running from the backup?This is a primary, 9.6.8 to be exact.>
> What can I do to repair this table?
One thing I tried on a database restored from a primary backup that exhibits the same "found update xid" error is this:
1. pg_dump the table and its referencing tables.
2. truncate the table and its referencing tables.
3. Load the dump file.
Does that seem reasonable?
В списке pgsql-general по дате отправления: