Tom Lane wrote:
T E Schmitz <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to