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