Tom Lane wrote:
> T E Schmitz <mailreg(at)numerixtechnology(dot)de> writes:
>
>>pg_dump: ERROR: timestamp out of range
>>pg_dump: SQL command to dump the contents of table "server_hit_bin"
>>failed: PQendcopy() failed.
>
>
> You should treat this as a corrupt-data exercise: you need to identify
> and fix (or delete) the offending row(s). In this case you might try
> tests like "bin_end_date_time > '1 Jan 9999'" and so on to see if you
> can determine exactly which rows are bad.
Dear Tom,
I can't thank you enough for the above advice. The test above identified
3 records and once they were removed I was able to dump the DB.
--
Best Regards,
Tarlika Elisabeth Schmitz