Re: Recovering data from an old disk image

On 7/15/16 11:37 AM, Richard Kuhns wrote:
> I've copied the entire pgsql directory to a new machine & installed the
> most recent 9.3 to try to read it. When I start the server it tells me
> that the database was initialized by version 9.4, so it can't handle it.
>
> I uninstalled 9.3 & installed the most recent 9.4. When I try to start
> it, it tells me:
>
> postgres[99770]: [1-1] FATAL:  database files are incompatible with server
> postgres[99770]: [1-2] DETAIL:  The database cluster was initialized
> with PG_CONTROL_VERSION 937, but the server was compiled with
> PG_CONTROL_VERSION 942.
>
> Based on a search of the mailing list archives I'm guessing that the
> original postgresql server was a 9.4 beta.

Yeah, based on that it looks like it might have been 9.4beta1.

If you can't find a tarball for that anywhere anymore, you can check out
the tag REL9_4_BETA1 from git and built it yourself.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services