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@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
