From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marc Millas <marc.millas@mokadb.com>
cc: Christophe Pettus <xof@thebuild.com>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: old OS
In-reply-to: <CADX_1aakUkM=ehvOtOGx2ELK=6+AxFmL8arvBs8D+xYhvjr7rA@mail.gmail.com>
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>
Comments: In-reply-to Marc Millas <marc.millas@mokadb.com>
	message dated "Tue, 04 Feb 2025 21:27:52 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <678717.1738701290.1@sss.pgh.pa.us>
Date: Tue, 04 Feb 2025 15:34:50 -0500
Message-ID: <678718.1738701290@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/678718.1738701290%40sss.pgh.pa.us>
Precedence: bulk

Marc Millas <marc.millas@mokadb.com> writes:
> 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.

I'm not really following why this requires any processing to be done
locally on the old machine.  You've got to shove the data over the
network sooner or later, so why not sooner?

			regards, tom lane