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...
On Tue, Feb 4, 2025 at 7:00 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Christophe Pettus <xof@xxxxxxxxxxxx> writes:
> On Feb 4, 2025, at 09:49, Marc Millas <marc.millas@xxxxxxxxxx> 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
