David De Maeyer wrote:
> I am now facing a puzzling challenge: converting binary timestamp
> data! If pgfsck did properly recover the timestamp data as a binary
> string, pgfsck will use a default timestamp, "1900-01-01 00:00:00",
> presumably because the date/time encoding varies from platform to
> platform.
There are two representations, one using 64 bit integers and the other
using floating point. Which one is your installation using depends on
compile-time settings.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support