MIME-Version: 1.0
References: <CADX_1aYvKS+tQj-G31ZK-hmsGm5jRwwFwgvTj8s40N0scrxTjA@mail.gmail.com>
 <E8911F85-438A-45C9-8879-9234DFE0C3AC@thebuild.com> <662807.1738692045@sss.pgh.pa.us>
 <CADX_1aakUkM=ehvOtOGx2ELK=6+AxFmL8arvBs8D+xYhvjr7rA@mail.gmail.com>
In-Reply-To: <CADX_1aakUkM=ehvOtOGx2ELK=6+AxFmL8arvBs8D+xYhvjr7rA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 4 Feb 2025 16:12:49 -0500
Message-ID: <CANzqJaAwc=Ob0=9i72LScgQjMpxMFfQauvkUW4d9xAvR3NBjYA@mail.gmail.com>
Subject: Re: old OS
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004cb85f062d57790d"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAwc%3DOb0%3D9i72LScgQjMpxMFfQauvkUW4d9xAvR3NBjYA%40mail.gmail.com>
Precedence: bulk

--0000000000004cb85f062d57790d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM 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=E2=80=AFPM 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
>>
>

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

--0000000000004cb85f062d57790d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><a href=3D"https://ora2pg.darold.net/">https://ora2pg=
.darold.net/</a></div><div><br></div><div>It can access remote Oracle datab=
ases, and migrate LOB columns to bytea.=C2=A0 Worked quite well for me on a=
 database 3x that size.</div><div><br></div><div dir=3D"ltr">On Tue, Feb 4,=
 2025 at 3:28=E2=80=AFPM Marc Millas &lt;<a href=3D"mailto:marc.millas@moka=
db.com">marc.millas@mokadb.com</a>&gt; wrote:</div><div class=3D"gmail_quot=
e gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<div dir=3D"ltr"><div>Hi Tom,</div><div><br></div><div>the data in the redh=
at 6.5 machine is NOT in Postgres, its in an old Oracle instance, 4TB of it=
.</div><div>So I am working on=C2=A0 a way to extract it to a file or, bett=
er to a pipe.</div><div>If I was able to get a local psql then, fine, i&#39=
;ll pipe the flow to it, done.(almost...)</div><div><br></div><div>If no lo=
cal postgres tool, as said, I will try to pipe data through the network,=C2=
=A0</div><div>but this imply that data will be put exactly as psql, on the =
new machine, will be able to &#39;ingest&#39; it.</div><div>easy for most t=
hings, somewhat more boring for blobs...</div><div><br></div><div><br></div=
><div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div><div=
 dir=3D"ltr">Marc MILLAS<div>Senior Architect</div><div>+33607850334</div><=
div><a href=3D"http://www.mokadb.com" target=3D"_blank">www.mokadb.com</a><=
/div><div><br></div></div></div></div></div></div><br></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Feb 4, 2025 =
at 7:00=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" target=
=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">Christophe Pettus &lt;<a href=3D"mailto:xof@th=
ebuild.com" target=3D"_blank">xof@thebuild.com</a>&gt; writes:<br>
&gt; On Feb 4, 2025, at 09:49, Marc Millas &lt;<a href=3D"mailto:marc.milla=
s@mokadb.com" target=3D"_blank">marc.millas@mokadb.com</a>&gt; wrote:<br>
&gt;&gt; My question is: is there any possibility to find something ?<br>
&gt;&gt; and/or what is the latest psql available on a redhat 6.5 ?<br>
<br>
&gt; Although I&#39;ve not done so, it should be possible to build from sou=
rce even on a system that old.<br>
<br>
Another workaround is to connect from a remote instance of psql.<br>
You&#39;d probably need to modify the server&#39;s pg_hba.conf and perhaps<=
br>
poke a hole in its firewall, but that&#39;s still easier than installing<br=
>
new software.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--0000000000004cb85f062d57790d--