Re: [GENERAL] error updating a tuple after promoting a standby - Mailing list pgsql-general

From Tom DalPozzo
Subject Re: [GENERAL] error updating a tuple after promoting a standby
Date
Msg-id CAK77FCTGWxWY7pXmoJg0Nk++y77MGawvqBcsNG7ktNwvDp_Ofg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] error updating a tuple after promoting a standby  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: Dylan Luong
Date:
Subject: [GENERAL] pgaudit_analyze process filling up audit log file
Next
From: Daniel Westermann
Date:
Subject: Re: [GENERAL] pg_restore to a port where nobody is listening?