Re: Error installing Postgres - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Error installing Postgres
Date
Msg-id 49EF4F3B.2080604@iol.ie
Whole thread Raw
In response to Error installing Postgres  (Christine Penner <christine@ingenioussoftware.com>)
Responses Re: Error installing Postgres
Re: Error installing Postgres
List pgsql-general
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
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Christine Penner
Date:
Subject: Error installing Postgres
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Error installing Postgres