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

Appears PG 12 is available for RHEL 6 via the following repository:

https://download.postgresql.org/pub/repos/yum/12/redhat/
<https://download.postgresql.org/pub/repos/yum/12/redhat/&gt;

If you need more reference, take a look at:
https://www.postgresql.org/download/linux/redhat/
<https://www.postgresql.org/download/linux/redhat/&gt;

Hope this helps,
Tim

On Tue, Feb 4, 2025 at 11:50 AM Marc Millas <marc.millas@mokadb.com> wrote:

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

Hi Tom,

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.
easy for most things, somewhat more boring for blobs...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Feb 4, 2025 at 7:00 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

👍👍👍

thanks

Marc MILLAS
Senior Architect
+33607850334

On Tue, Feb 4, 2025 at 7:04 PM Tim Gerber <tggerber@gmail.com> wrote:

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

https://ora2pg.darold.net/

It can access remote Oracle databases, and migrate LOB columns to bytea.
Worked quite well for me on a database 3x that size.

On Tue, Feb 4, 2025 at 3:28 PM Marc Millas <marc.millas@mokadb.com> wrote:

Hi Tom,

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.
easy for most things, somewhat more boring for blobs...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Tue, Feb 4, 2025 at 7:00 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

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

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!