At our company we had a DB crash a few days ago due to hardware reasons. We recovered from that but since then we're having this following error every time we try to back up our DB.
pg_dump: ERROR: timestamp out of range
pg_dump: SQL command to dump the contents of table "account_bank_statement_line"
The error is in "account_bank_statement_line" table, where we have 5 rows created with only the 'create_date' column has a date of year 4855(!!!!), the rest of the columns have null value, even the id (primary key). We can't even delete or update those rows using pgAdmin 4.
Did you try to update / delete those records using query from postgres command line?
Already tried that, didn't work either.
Any other solutions, please?
Are you getting similar error while doing this from command line?
May be you can try to migrate the whole database to new database, not sure how. May be with the script or something else.
Please explain, how you are taking backup? using PSQL Query or From ODOO UI or by any third party APPS