Re: old OS

2025-02-04 Thread Ron Johnson
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 wrote: > Hi Tom, > > the data in the redhat 6.5 machine is NOT in Postgres, its in an old > Oracle

Re: old OS

2025-02-04 Thread Adrian Klaver
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.kla...@aklaver.com

Re: old OS

2025-02-04 Thread Tom Lane
Marc Millas 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 lo

Re: old OS

2025-02-04 Thread Marc Millas
👍👍👍 thanks Marc MILLAS Senior Architect +33607850334 On Tue, Feb 4, 2025 at 7:04 PM Tim Gerber wrote: > Appears PG 12 is available for RHEL 6 via the following repository: > > https://download.postgresql.org/pub/repos/yum/12/redhat/ >

Re: old OS

2025-02-04 Thread Marc Millas
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 s

Re: old OS

2025-02-04 Thread Adrian Klaver
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.o

Re: old OS

2025-02-04 Thread Tim Gerber
Appears PG 12 is available for RHEL 6 via the following repository: https://download.postgresql.org/pub/repos/yum/12/redhat/ If you need more reference, take a look at: https://www.postgresql.org/download/linux/redhat/

Re: old OS

2025-02-04 Thread Christophe Pettus
> On Feb 4, 2025, at 09:49, Marc Millas 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.

Re: old OS

2025-02-04 Thread Tom Lane
Christophe Pettus writes: > On Feb 4, 2025, at 09:49, Marc Millas 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 OS

2025-02-04 Thread Marc Millas
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. My question is: is there any possibility to find something ? and/or what is the latest psql available