Re: How to recover data from 9.3 data directory

On 3/13/21 12:04 PM, Andrus wrote: Or you could just use the the Postgres APT repo, as example: https://apt.postgresql.org/pub/repos/apt/dists/stretch-pgdg/9.3/ see also https://wiki.postgresql.org/wiki/Apt/FAQ#W

Re: How to recover data from 9.3 data directory

Or you could just use the the Postgres APT repo, as example: https://apt.postgresql.org/pub/repos/apt/dists/stretch-pgdg/9.3/ see also https://wiki.postgresql.org/wiki/Apt/FAQ#Where_are_older_versions_of_the_packa

Re: How to recover data from 9.3 data directory

Le dim. 14 mars 2021 à 00:17, Adrian Klaver a écrit : > On 3/13/21 7:25 AM, Andrus wrote: > > Hi! > > > > >Debian does not offer to install Postgres 9.3 into it. How to install > > postgres 9.3 in new Debian ? > > > >> > >> >You'll have to compile it. > > > > Enterpisedb offers 9.3 download for

Re: How to recover data from 9.3 data directory

On 3/13/21 7:25 AM, Andrus wrote: Hi! >Debian does not offer to install Postgres 9.3 into it. How to install postgres 9.3 in new Debian ? >You'll have to compile it. Enterpisedb offers 9.3 download for Linux in https://www.enterprisedb.com/downloads/postgres-postgresql-downloads Maybe

Re: How to recover data from 9.3 data directory

Hi! >Debian does not offer to install Postgres 9.3 into it. How to install postgres 9.3 in new Debian ? >You'll have to compile it. Enterpisedb offers 9.3 download for Linux in https://www.enterprisedb.com/downloads/postgres-postgresql-downloads Maybe it is possible to install it in new

Re: How to recover data from 9.3 data directory

Le sam. 13 mars 2021 à 15:18, Andrus a écrit : > Should I create virtual machine and install Linux with 9.3 into it or is >> there simpler solution? >> > that's the only option, unless you already have some compatible server > around. > > I have new Debian virtual machine with Postgres 12 . > >

Re: How to recover data from 9.3 data directory

Should I create virtual machine and install Linux with 9.3 into it or is there simpler solution? that's the only option, unless you already have some compatible server around. I have new Debian virtual machine with Postgres 12  . Debian does not offer to install Postgres 9.3 into it. Ho

Re: How to recover data from 9.3 data directory

Le sam. 13 mars 2021 à 22:02, Andrus a écrit : > Hi! > > > 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. > > wal archiving works between Linux and Windows. So I expected those > commands

Re: How to recover data from 9.3 data directory

Hi! > 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. wal archiving works between Linux and Windows. So I expected those commands to work also. How to determine is this data from 32 or 6

Re: How to recover data from 9.3 data directory

Le sam. 13 mars 2021 à 21:29, Andrus 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

How to recover data from 9.3 data directory

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.ex