Re: Error installing Postgres

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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------