Re: old OS

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: old OS
Date: 2025-02-04 20:27:52
Message-ID: CADX_1aakUkM=ehvOtOGx2ELK=6+AxFmL8arvBs8D+xYhvjr7rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Responses

  • Re: old OS at 2025-02-04 20:34:50 from Tom Lane
  • Re: old OS at 2025-02-04 20:58:24 from Adrian Klaver
  • Re: old OS at 2025-02-04 21:12:49 from Ron Johnson

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2025-02-04 20:32:46 Re: old OS
Previous Message Adrian Klaver 2025-02-04 20:02:19 Re: Table copy