Thread: old OS

> On Feb 4, 2025, at 09:49, Marc Millas <marc.millas@mokadb.com> wrote:
> My question is: is there any possibility to find something ?
> and/or what is the latest psql available on a redhat 6.5 ?

Although I've not done so, it should be possible to build from source even on a system that old.

Christophe Pettus <xof@thebuild.com> writes:
> On Feb 4, 2025, at 09:49, Marc Millas <marc.millas@mokadb.com> wrote:
>> My question is: is there any possibility to find something ?
>> and/or what is the latest psql available on a redhat 6.5 ?

> Although I've not done so, it should be possible to build from source even on a system that old.

Another workaround is to connect from a remote instance of psql.
You'd probably need to modify the server's pg_hba.conf and perhaps
poke a hole in its firewall, but that's still easier than installing
new software.

            regards, tom lane

On 2/4/25 09:49, Marc Millas wrote:
> Hi,
> 
> I need to install psql on a redhat 6.5 Linux, to transfert local data to 
> a distant
>   postgreSQL 16 DB.
> Too my understanding, as this redhat version is EOL for long, No such 
> psql is available.

There are the PGDG archive repos:

https://yum.postgresql.org/repopackages/#pgredhatoldrepos

For RH 6.* looks like it goes up to Postgres 11.

> 
> My question is: is there any possibility to find something ?
> and/or what is the latest psql available on a redhat 6.5 ?
> 
> If nothing, I will try to pipe the data directly through the network 
> connection, but this generates other problems.
> 
> thanks for your help
> 
> Marc MILLAS
> Senior Architect
> +33607850334
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

Marc Millas <marc.millas@mokadb.com> writes:
> the data in the redhat 6.5 machine is NOT in Postgres, its in an old Oracle
> instance, 4TB of it.
> So I am working on  a way to extract it to a file or, better to a pipe.
> If I was able to get a local psql then, fine, i'll pipe the flow to it,
> done.(almost...)
> If no local postgres tool, as said, I will try to pipe data through the
> network,
> but this imply that data will be put exactly as psql, on the new machine,
> will be able to 'ingest' it.

I'm not really following why this requires any processing to be done
locally on the old machine.  You've got to shove the data over the
network sooner or later, so why not sooner?

            regards, tom lane

On 2/4/25 12:27, Marc Millas wrote:
> Hi Tom,
> 
> the data in the redhat 6.5 machine is NOT in Postgres, its in an old 
> Oracle instance, 4TB of it.

Maybe?:

https://github.com/laurenz/oracle_fdw


-- 
Adrian Klaver
adrian.klaver@aklaver.com