Re: pg_dump fails (timestamp out of range)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mailreg(at)numerixtechnology(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump fails (timestamp out of range)
Date: 2007-02-22 15:43:33
Message-ID: 5458.1172159013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

T E Schmitz <mailreg(at)numerixtechnology(dot)de> writes:
> However, I am stalled because pg_dump fails with the following error:

> 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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Fetter 2007-02-22 16:56:48 Re: how to generate a list of distinct scalar values from a column which type is array
Previous Message Sabin Coanda 2007-02-22 13:47:14 Re: How compare current_setting(..) ?