Re: old OS

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(dot)millas(at)mokadb(dot)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Christophe Pettus <xof(at)thebuild(dot)com> writes:
>> > On Feb 4, 2025, at 09:49, Marc Millas <marc(dot)millas(at)mokadb(dot)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!