Re: [GENERAL] error updating a tuple after promoting a standby

Поиск
Список
Период
Сортировка
От Tom DalPozzo
Тема Re: [GENERAL] error updating a tuple after promoting a standby
Дата
Msg-id CAK77FCTGWxWY7pXmoJg0Nk++y77MGawvqBcsNG7ktNwvDp_Ofg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] error updating a tuple after promoting a standby  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения


If it where me I would use one of the -X methods:

https://www.postgresql.org/docs/9.5/static/app-pgbasebackup.html



To me that looks like an issue with the associated TOAST table. I do not have a suggestion at this time. Maybe this rings a bell with someone else.

--
Adrian Klaver
adrian.klaver@aklaver.com

Good tip, x method, I will try it, sure. 
But I'm also afraid that there is a still hidden issue.
I think that I'm using postgres in a context slightly different from the usual ones (many many updates of a table rows with big field, replication,...) so I'm afraid that issues not already seen can appear.
Regards
Pupillo

В списке pgsql-general по дате отправления:

Предыдущее
От: Dylan Luong
Дата:
Сообщение: [GENERAL] pgaudit_analyze process filling up audit log file
Следующее
От: Daniel Westermann
Дата:
Сообщение: Re: [GENERAL] pg_restore to a port where nobody is listening?