How to recover data from 9.3 data directory

From: Andrus <kobruleht2(at)hot(dot)ee>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to recover data from 9.3 data directory
Date: 2021-03-13 13:28:37
Message-ID: bad0d6a7-000b-9ce5-ac43-6269aae556a2@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

There is data directory from Postgres 9.3 server from old Centos.

Centos server is not running anymore and there is window 10 workstation
to recover.

1. Tried to recover data from it installing 9.3 and 13 servers in
windows 10 and using

"C:\Program Files\PostgreSQL\13\bin\pg_upgrade.exe" ^
--old-datadir "D:/Centos93Data/data" ^
--new-datadir "C:/Program Files/PostgreSQL/13/data" ^
--old-bindir "C:/Program Files/PostgreSQL/9.3/bin" ^
--new-bindir "C:/Program Files/PostgreSQL/13/bin"

It complained that postmaster seems working. I deleted postmaster.pid
file. Now it throws  error

Performing Consistency Checks
Checking cluster versions ok
The source cluster was not shut down cleanly.
Failure, exiting

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 ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2021-03-13 13:43:54 Re: pg_upgrade and wraparound
Previous Message Michael Paquier 2021-03-13 01:30:44 Re: pg_upgrade and wraparound