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>
In-Reply-To: <662807.1738692045@sss.pgh.pa.us>
From: Marc Millas <marc.millas@mokadb.com>
Date: Tue, 4 Feb 2025 21:27:52 +0100
Message-ID: <CADX_1aakUkM=ehvOtOGx2ELK=6+AxFmL8arvBs8D+xYhvjr7rA@mail.gmail.com>
Subject: Re: old OS
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Christophe Pettus <xof@thebuild.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008ab0b7062d56d8fc"
Archived-At: <https://www.postgresql.org/message-id/CADX_1aakUkM%3DehvOtOGx2ELK%3D6%2BAxFmL8arvBs8D%2BxYhvjr7rA%40mail.gmail.com>
Precedence: bulk

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

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
>

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

<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" data-smartmail=3D"gmail_si=
gnature"><div dir=3D"ltr"><div><div dir=3D"ltr">Marc MILLAS<div>Senior Arch=
itect</div><div>+33607850334</div><div><a href=3D"http://www.mokadb.com" ta=
rget=3D"_blank">www.mokadb.com</a></div><div><br></div></div></div></div></=
div></div><br></div><br><div class=3D"gmail_quote gmail_quote_container"><d=
iv 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">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(204,204,204);padding-left:1ex">Christop=
he Pettus &lt;<a href=3D"mailto:xof@thebuild.com" target=3D"_blank">xof@the=
build.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>

--0000000000008ab0b7062d56d8fc--