Re: Data directory was initialized by PostgreSQL version 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Data directory was initialized by PostgreSQL version 8.3
Date: 2007-07-25 03:13:10
Message-ID: 29879.1185333190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> writes:
>>> 2007-07-25 11:52:05 EST @ []DETAIL: The data directory was initialized
>>> by
>>> PostgreSQL version 8.3, which is not compatible with this version 8.2.4.

> Is it worth me trying to fix this stuff up on my behalf? Or should I just go
> back to last night's backup and recreate this morning's transactions?

If you can reinstall the server software you had yesterday, do that and
do a pg_dumpall, then install 8.2.4, initdb, reload from dump.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vishal Arora 2007-07-25 04:11:20 Re: Installing PgAdmin package on Linux
Previous Message Phillip Smith 2007-07-25 03:02:28 Re: Data directory was initialized by PostgreSQL version 8.3