Re: Error installing Postgres

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Christine Penner <christine(at)ingenioussoftware(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error installing Postgres
Date: 2009-04-22 17:09:15
Message-ID: 49EF4F3B.2080604@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-04-22 17:12:42 Re: Error installing Postgres
Previous Message Mikko 2009-04-22 17:06:24 Re: trouble with to_char('L')