Re: Error installing Postgres

On Wed, 2009-04-22 at 10:13 -0700, Christine Penner wrote:
> I am upgrading from 8.3.4 to 8.3.7. That's why I'm confused. The
> notes said I wouldn't have to do that. 8.3.4 was the original install.

What OS are you running? How did you go about upgrading?

Debian/Ubuntu will use --integer-datetimes by default. If the machine
was once compiled from source you could see the problem.

RedHat/Cent/Fedora has long used the incorrect default of floating based
timestamps. If you downloaded the wrong package from pgsqlrpms then you
could run into the error (pgsqlrpms has both --integer-datetimes and
floating based packages (for compatibility).

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997