| 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: | Whole Thread | Raw Message | 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
------------------------------------------------------------------
| 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') |