Re: How to recover data from 9.3 data directory

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to recover data from 9.3 data directory
Date: 2021-03-13 13:45:52
Message-ID: CAOBaU_bXToOWQuBVUDHAOp0342d_Nz_N2p_zOoOO8Vv4+1oYqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le sam. 13 mars 2021 à 21:29, Andrus <kobruleht2(at)hot(dot)ee> a écrit :

> 2. Tried to run old server using
>
C:\Program Files\PostgreSQL\9.3\bin\pg_ctl.exe" start -D
> "D:/Centos93Data/data"
> got error
>
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with USE_FLOAT8_BYVAL but
> the server was compiled without USE_FLOAT8_BYVAL.
> HINT: It looks like you need to recompile or initdb.
>
> I tried both 32 and 64 bit 9.3 servers in windows but error is the same.
>
> How to recover data from 9.3 linux directory ?
>
that won't work on windows. pg_upgrade only works if source and target
environment are binary compatible, which isn't the case for windows / GNU
Linux.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2021-03-13 14:02:19 Re: How to recover data from 9.3 data directory
Previous Message Jan Wieck 2021-03-13 13:43:54 Re: pg_upgrade and wraparound