On Wed, 2009-04-22 at 18:09 +0100, Raymond O'Donnell wrote:
> On 22/04/2009 16:57, Christine Penner wrote:
>
> > The existing data directory (Date/time settings: floating -point
> > numbers) is not compatible with this server (Date/Time setting: 64-bit
> > integers)
> >
> > I saw a few posts about this but I'm still not sure how to fix it. I
> > think one of them said I need to completely remove Postgres and do a
> > dump and restore. Is that the only way?
>
> It sounds as if you're trying to get a later-version server to use an
> earlier-version data directory - this won't work.
Actually the error is about whether or not the server was compiled with
integer datetime support. There may also be an upgrade error here as
well if she is trying to use 8.4Beta because 8.4 finally fixes the long
standing mistake of not using integer datetime support by default.
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