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. Between major versions of PostgreSQL (8.2 -> 8.3 for example) you *have* to do a dump/restore - it says this in the docs and (I think) in the release notes. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
